<!DOCTYPE HTML>
<html lang="en-US" manifest="../manifest.appcache">
    
    <head>
        
        <meta charset="UTF-8">
        <title>页面溢出 | SQlite源码分析</title>
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <meta name="description" content="">
        <meta name="generator" content="GitBook 0.7.0">
        <meta name="HandheldFriendly" content="true"/>
        <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
        <meta name="apple-mobile-web-app-capable" content="yes">
        <meta name="apple-mobile-web-app-status-bar-style" content="black">
        <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">
        
    
    
    
    <link rel="next" href="../B-treeImplementation/b-tree_api.html" />
    
    
    <link rel="prev" href="../B-treeImplementation/hierarchicalorganization.html" />
    

        
    </head>
    <body>
        
        
<link rel="stylesheet" href="../gitbook/style.css">


        
    <div class="book"  data-level="5.2.3" data-basepath=".." data-revision="1426425870398">
    <div class="book-header">
    <!-- Actions Left -->
    <a href="#" class="btn pull-left toggle-summary" aria-label="Toggle summary"><i class="fa fa-align-justify"></i></a>
    
    <a href="https://github.com/null" target="_blank" class="btn pull-left home-bookmark" aria-label="GitHub home"><i class="fa fa-bookmark-o"></i></a>
    
    <a href="#" class="btn pull-left toggle-search" aria-label="Toggle search"><i class="fa fa-search"></i></a>
    <span id="font-settings-wrapper">
        <a href="#" class="btn pull-left toggle-font-settings" aria-label="Toggle font settings"><i class="fa fa-font"></i>
        </a>
        <div class="dropdown-menu font-settings">
    <div class="dropdown-caret">
        <span class="caret-outer"></span>
        <span class="caret-inner"></span>
    </div>

    <div class="btn-group btn-block">
        <button id="reduce-font-size" class="btn btn-default">A</button>
        <button id="enlarge-font-size" class="btn btn-default">A</button>
    </div>

    <ul class="list-group font-family-list">
        <li class="list-group-item" data-font="0">Serif</li>
        <li class="list-group-item" data-font="1">Sans</li>
    </ul>

    <div class="btn-group btn-group-xs btn-block color-theme-list">
        <button type="button" class="btn btn-default" id="color-theme-preview-0" data-theme="0">White</button>
        <button type="button" class="btn btn-default" id="color-theme-preview-1" data-theme="1">Sepia</button>
        <button type="button" class="btn btn-default" id="color-theme-preview-2" data-theme="2">Night</button>
    </div>
</div>

    </span>

    <!-- Actions Right -->
    
    <a href="#" target="_blank" class="btn pull-right google-plus-sharing-link sharing-link" data-sharing="google-plus" aria-label="Share on Google Plus"><i class="fa fa-google-plus"></i></a>
    
    
    <a href="#" target="_blank" class="btn pull-right facebook-sharing-link sharing-link" data-sharing="facebook" aria-label="Share on Facebook"><i class="fa fa-facebook"></i></a>
    
    
    <a href="#" target="_blank" class="btn pull-right twitter-sharing-link sharing-link" data-sharing="twitter" aria-label="Share on Twitter"><i class="fa fa-twitter"></i></a>
    
    

    <!-- Title -->
    <h1>
        <i class="fa fa-spinner fa-spin"></i>
        <a href="../" >SQlite源码分析</a>
    </h1>
</div>

    

<div class="book-summary">
    <div class="book-search">
        <input type="text" placeholder="Search" class="form-control" />
    </div>
    <ul class="summary">
        
        

        

        

	

        

        
    
        
        <li class="chapter " data-level="0" data-path="index.html">
            
                
                    <a href="../index.html">
                        <i class="fa fa-check"></i>
                        
                         首页
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="1" data-path="sqlite/sqliteintro.html">
            
                
                    <a href="../sqlite/sqliteintro.html">
                        <i class="fa fa-check"></i>
                        
                            <b>1.</b>
                        
                         SQLite简介
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="1.1" data-path="vdbemem/vdbememsqliteintro.html">
            
                
                    <a href="../vdbemem/vdbememsqliteintro.html">
                        <i class="fa fa-check"></i>
                        
                            <b>1.1.</b>
                        
                         SQLite特性
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="1.2" data-path="sqlite/introduce.html">
            
                
                    <a href="../sqlite/introduce.html">
                        <i class="fa fa-check"></i>
                        
                            <b>1.2.</b>
                        
                         推荐使用场景
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="1.3" data-path="sqlite/READMEG14.html">
            
                
                    <a href="../sqlite/READMEG14.html">
                        <i class="fa fa-check"></i>
                        
                            <b>1.3.</b>
                        
                         快速使用SQLite
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="2" data-path="sqlite/architecture.html">
            
                
                    <a href="../sqlite/architecture.html">
                        <i class="fa fa-check"></i>
                        
                            <b>2.</b>
                        
                         SQLite体系结构
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="2.1" data-path="sqlite/system.html">
            
                
                    <a href="../sqlite/system.html">
                        <i class="fa fa-check"></i>
                        
                            <b>2.1.</b>
                        
                         体系结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="2.2" data-path="sqlite/sqlitemodule.html">
            
                
                    <a href="../sqlite/sqlitemodule.html">
                        <i class="fa fa-check"></i>
                        
                            <b>2.2.</b>
                        
                         各结构作用
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="3" data-path="vdbemem/summary.html">
            
                
                    <a href="../vdbemem/summary.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.</b>
                        
                         进程模型
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.1" data-path="vdbeInt&amp;vdbemem887/whatIsVdbe.html">
            
                
                    <a href="../vdbeInt&amp;vdbemem887/whatIsVdbe.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.1.</b>
                        
                         什么是VDBE
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.1.1" data-path="vdbeInt&amp;vdbemem887/sqlite&amp;vdbe.html">
            
                
                    <a href="../vdbeInt&amp;vdbemem887/sqlite&amp;vdbe.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.1.1.</b>
                        
                         sqLite为什么要使用虚拟机
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.1.2" data-path="vdbeInt&amp;vdbemem887/vdbeProcess.html">
            
                
                    <a href="../vdbeInt&amp;vdbemem887/vdbeProcess.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.1.2.</b>
                        
                         VDBE的运行
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.1.3" data-path="vdbeInt&amp;vdbemem887/vdbeInt.html">
            
                
                    <a href="../vdbeInt&amp;vdbemem887/vdbeInt.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.1.3.</b>
                        
                         vdbeInt.h简介
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="3.2" data-path="vdbe/README.html">
            
                
                    <a href="../vdbe/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.2.</b>
                        
                         VDBE执行方法
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3" data-path="execuing_of_vdbec/README.html">
            
                
                    <a href="../execuing_of_vdbec/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.</b>
                        
                         SQLite执行与VDBE
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.3.1" data-path="execuing_of_vdbec/op_init.html">
            
                
                    <a href="../execuing_of_vdbec/op_init.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.1.</b>
                        
                         OP_Init
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.2" data-path="execuing_of_vdbec/op_transaction.html">
            
                
                    <a href="../execuing_of_vdbec/op_transaction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.2.</b>
                        
                         OP_Transaction
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.3" data-path="execuing_of_vdbec/op_tablelock.html">
            
                
                    <a href="../execuing_of_vdbec/op_tablelock.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.3.</b>
                        
                         OP_TableLock
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.4" data-path="execuing_of_vdbec/op_goto.html">
            
                
                    <a href="../execuing_of_vdbec/op_goto.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.4.</b>
                        
                         OP_Goto
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.5" data-path="execuing_of_vdbec/op_readcookie.html">
            
                
                    <a href="../execuing_of_vdbec/op_readcookie.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.5.</b>
                        
                         OP_ReadCookie
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.6" data-path="execuing_of_vdbec/op_if.html">
            
                
                    <a href="../execuing_of_vdbec/op_if.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.6.</b>
                        
                         OP_If
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.7" data-path="execuing_of_vdbec/op_integer1.html">
            
                
                    <a href="../execuing_of_vdbec/op_integer1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.7.</b>
                        
                         OP_Integer1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.8" data-path="execuing_of_vdbec/op_setcookie.html">
            
                
                    <a href="../execuing_of_vdbec/op_setcookie.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.8.</b>
                        
                         OP_SetCookie
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.9" data-path="execuing_of_vdbec/op_integer2.html">
            
                
                    <a href="../execuing_of_vdbec/op_integer2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.9.</b>
                        
                         OP_Integer2
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.10" data-path="execuing_of_vdbec/op_setcookie.html">
            
                
                    <a href="../execuing_of_vdbec/op_setcookie.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.10.</b>
                        
                         OP_SetCookie
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.11" data-path="execuing_of_vdbec/op_createtable.html">
            
                
                    <a href="../execuing_of_vdbec/op_createtable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.11.</b>
                        
                         OP_CreateTable
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.12" data-path="execuing_of_vdbec/op_openwrite.html">
            
                
                    <a href="../execuing_of_vdbec/op_openwrite.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.12.</b>
                        
                         OP_OpenWrite
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.13" data-path="execuing_of_vdbec/op_newrowid.html">
            
                
                    <a href="../execuing_of_vdbec/op_newrowid.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.13.</b>
                        
                         OP_NewRowid
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.14" data-path="execuing_of_vdbec/op_null1.html">
            
                
                    <a href="../execuing_of_vdbec/op_null1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.14.</b>
                        
                         OP_Null1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.15" data-path="execuing_of_vdbec/op_insert.html">
            
                
                    <a href="../execuing_of_vdbec/op_insert.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.15.</b>
                        
                         OP_Insert
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.16" data-path="execuing_of_vdbec/op_close1.html">
            
                
                    <a href="../execuing_of_vdbec/op_close1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.16.</b>
                        
                         OP_Close1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.17" data-path="execuing_of_vdbec/op_close2.html">
            
                
                    <a href="../execuing_of_vdbec/op_close2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.17.</b>
                        
                         OP_Close2
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.18" data-path="execuing_of_vdbec/op_null2.html">
            
                
                    <a href="../execuing_of_vdbec/op_null2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.18.</b>
                        
                         OP_Null2
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.19" data-path="execuing_of_vdbec/op_openwrite1.html">
            
                
                    <a href="../execuing_of_vdbec/op_openwrite1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.19.</b>
                        
                         OP_OpenWrite1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.20" data-path="execuing_of_vdbec/op_mustbeint.html">
            
                
                    <a href="../execuing_of_vdbec/op_mustbeint.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.20.</b>
                        
                         OP_MustBeInt
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.21" data-path="execuing_of_vdbec/op_notexists.html">
            
                
                    <a href="../execuing_of_vdbec/op_notexists.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.21.</b>
                        
                         OP_NotExists
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.22" data-path="execuing_of_vdbec/op_rowid.html">
            
                
                    <a href="../execuing_of_vdbec/op_rowid.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.22.</b>
                        
                         OP_Rowid
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.23" data-path="execuing_of_vdbec/op_isnull.html">
            
                
                    <a href="../execuing_of_vdbec/op_isnull.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.23.</b>
                        
                         OP_IsNull
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.24" data-path="execuing_of_vdbec/op_string.html">
            
                
                    <a href="../execuing_of_vdbec/op_string.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.24.</b>
                        
                         OP_String
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.25" data-path="execuing_of_vdbec/op_string1.html">
            
                
                    <a href="../execuing_of_vdbec/op_string1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.25.</b>
                        
                         OP_String1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.26" data-path="execuing_of_vdbec/op_string2.html">
            
                
                    <a href="../execuing_of_vdbec/op_string2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.26.</b>
                        
                         OP_String2
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.27" data-path="execuing_of_vdbec/op_copy.html">
            
                
                    <a href="../execuing_of_vdbec/op_copy.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.27.</b>
                        
                         OP_Copy
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.28" data-path="execuing_of_vdbec/op_string3.html">
            
                
                    <a href="../execuing_of_vdbec/op_string3.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.28.</b>
                        
                         OP_String3
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.29" data-path="execuing_of_vdbec/op_makerecord.html">
            
                
                    <a href="../execuing_of_vdbec/op_makerecord.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.29.</b>
                        
                         OP_MakeRecord
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.30" data-path="execuing_of_vdbec/op_insert1.html">
            
                
                    <a href="../execuing_of_vdbec/op_insert1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.30.</b>
                        
                         OP_Insert1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.31" data-path="execuing_of_vdbec/op_close3.html">
            
                
                    <a href="../execuing_of_vdbec/op_close3.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.31.</b>
                        
                         OP_Close3
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.32" data-path="execuing_of_vdbec/op_integer3.html">
            
                
                    <a href="../execuing_of_vdbec/op_integer3.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.32.</b>
                        
                         OP_Integer3
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.33" data-path="execuing_of_vdbec/op_setcookie1.html">
            
                
                    <a href="../execuing_of_vdbec/op_setcookie1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.33.</b>
                        
                         OP_SetCookie1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.34" data-path="execuing_of_vdbec/op_parseschema.html">
            
                
                    <a href="../execuing_of_vdbec/op_parseschema.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.34.</b>
                        
                         OP_ParseSchema
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.3.35" data-path="execuing_of_vdbec/op_halt.html">
            
                
                    <a href="../execuing_of_vdbec/op_halt.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.3.35.</b>
                        
                         OP_Halt
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="3.4" data-path="execuing_procedure_of_vdbe/README.html">
            
                
                    <a href="../execuing_procedure_of_vdbe/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.4.</b>
                        
                         SQLite执行过程
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.5" data-path="vdbeauxc/preview.html">
            
                
                    <a href="../vdbeauxc/preview.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.5.</b>
                        
                         vdbeaux.c源码概览
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6" data-path="vdbeauxc/intrduceandanaly.html">
            
                
                    <a href="../vdbeauxc/intrduceandanaly.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.</b>
                        
                         vdbeaux.c 源码介绍与分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.6.1" data-path="vdbeauxc/createfame.html">
            
                
                    <a href="../vdbeauxc/createfame.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.1.</b>
                        
                         创建vdbe结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.2" data-path="vdbeauxc/prepare.html">
            
                
                    <a href="../vdbeauxc/prepare.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.2.</b>
                        
                         vdbe准备阶段
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.6.2.1" data-path="vdbeauxc/update.html">
            
                
                    <a href="../vdbeauxc/update.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.2.1.</b>
                        
                         相关修改函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.2.2" data-path="vdbeauxc/assemble.html">
            
                
                    <a href="../vdbeauxc/assemble.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.2.2.</b>
                        
                         配置函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.2.3" data-path="vdbeauxc/xigou.html">
            
                
                    <a href="../vdbeauxc/xigou.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.2.3.</b>
                        
                         析构函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="3.6.3" data-path="vdbeauxc/debug.html">
            
                
                    <a href="../vdbeauxc/debug.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.3.</b>
                        
                         debug模式
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.6.3.1" data-path="vdbeauxc/deleframe.html">
            
                
                    <a href="../vdbeauxc/deleframe.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.3.1.</b>
                        
                         删除vdbe结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.3.2" data-path="vdbeauxc/list.html">
            
                
                    <a href="../vdbeauxc/list.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.3.2.</b>
                        
                         列出虚拟机中的程序清单
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.3.3" data-path="vdbeauxc/display.html">
            
                
                    <a href="../vdbeauxc/display.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.3.3.</b>
                        
                         显示部分
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="3.6.4" data-path="vdbeauxc/alloc.html">
            
                
                    <a href="../vdbeauxc/alloc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.4.</b>
                        
                         分配空间
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.5" data-path="vdbeauxc/init.html">
            
                
                    <a href="../vdbeauxc/init.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.5.</b>
                        
                         初始化vdbe
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.6" data-path="vdbeauxc/makeready.html">
            
                
                    <a href="../vdbeauxc/makeready.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.6.</b>
                        
                         执行前的准备
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.7" data-path="vdbeauxc/free.html">
            
                
                    <a href="../vdbeauxc/free.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.7.</b>
                        
                         释放资源
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8" data-path="vdbeauxc/process.html">
            
                
                    <a href="../vdbeauxc/process.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.</b>
                        
                         vdbe执行中的处理
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.6.8.1" data-path="vdbeauxc/halt.html">
            
                
                    <a href="../vdbeauxc/halt.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.1.</b>
                        
                         函数sqlite3VdbeHalt
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.2" data-path="vdbeauxc/stepresult.html">
            
                
                    <a href="../vdbeauxc/stepresult.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.2.</b>
                        
                         函数sqlite3VdbeResetStepResult
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.3" data-path="vdbeauxc/transfererror.html">
            
                
                    <a href="../vdbeauxc/transfererror.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.3.</b>
                        
                         函数sqlite3VdbeTransferError
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.4" data-path="vdbeauxc/reset.html">
            
                
                    <a href="../vdbeauxc/reset.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.4.</b>
                        
                         函数sqlite3VdbeReset
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.5" data-path="vdbeauxc/finalize.html">
            
                
                    <a href="../vdbeauxc/finalize.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.5.</b>
                        
                         函数sqlite3VdbeFinalize
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.6" data-path="vdbeauxc/deleobjectanddelete.html">
            
                
                    <a href="../vdbeauxc/deleobjectanddelete.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.6.</b>
                        
                         函数sqlite3VdbeDeleteObject和sqlite3VdbeDelete
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.7" data-path="vdbeauxc/moveto.html">
            
                
                    <a href="../vdbeauxc/moveto.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.7.</b>
                        
                         函数sqlite3VdbeCursorMoveto
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.8" data-path="vdbeauxc/flowswap.html">
            
                
                    <a href="../vdbeauxc/flowswap.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.8.</b>
                        
                         函数u64 floatSwap
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.9" data-path="vdbeauxc/serialput.html">
            
                
                    <a href="../vdbeauxc/serialput.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.9.</b>
                        
                         函数sqlite3VdbeSerialPut
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.10" data-path="vdbeauxc/unpackedrecord.html">
            
                
                    <a href="../vdbeauxc/unpackedrecord.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.10.</b>
                        
                         函数sqlite3VdbeAllocUnpackedRecord
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.11" data-path="vdbeauxc/statements.html">
            
                
                    <a href="../vdbeauxc/statements.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.11.</b>
                        
                         函数sqlite3ExpirePreparedStatements
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.6.8.12" data-path="vdbeauxc/setvarmask.html">
            
                
                    <a href="../vdbeauxc/setvarmask.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.6.8.12.</b>
                        
                         函数sqlite3VdbeSetVarmask
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="3.7" data-path="vdbesort/preview2.html">
            
                
                    <a href="../vdbesort/preview2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.7.</b>
                        
                         vdbesort.c源码概览
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="3.7.1" data-path="vdbesort/nintrodution.html">
            
                
                    <a href="../vdbesort/nintrodution.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.7.1.</b>
                        
                         N-路归并的算法及数据结构说明
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.7.2" data-path="vdbesort/structs.html">
            
                
                    <a href="../vdbesort/structs.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.7.2.</b>
                        
                         结构体定义
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="3.7.3" data-path="vdbesort/functions.html">
            
                
                    <a href="../vdbesort/functions.html">
                        <i class="fa fa-check"></i>
                        
                            <b>3.7.3.</b>
                        
                         函数定义
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4" data-path="srcAnaly/README.html">
            
                
                    <a href="../srcAnaly/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.</b>
                        
                         关系查询处理器
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.1" data-path="srcAnaly/selectExec.html">
            
                
                    <a href="../srcAnaly/selectExec.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.</b>
                        
                         查询解析和授权
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.1.1" data-path="sqlite/sqlasunderstoodbysqlite.html">
            
                
                    <a href="../sqlite/sqlasunderstoodbysqlite.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.1.</b>
                        
                         SQLite中的SQL语句
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.2" data-path="dir2/selectgrammar.html">
            
                
                    <a href="../dir2/selectgrammar.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.2.</b>
                        
                         SELECT的语法图
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.3" data-path="dir2/selectexe.html">
            
                
                    <a href="../dir2/selectexe.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.3.</b>
                        
                         SQLite中SQL语句执行步骤
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.4" data-path="srcAnaly/keyFunc.html">
            
                
                    <a href="../srcAnaly/keyFunc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.4.</b>
                        
                         sqlite查询处理的关键函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.5" data-path="dir2/selecttree.html">
            
                
                    <a href="../dir2/selecttree.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.5.</b>
                        
                         查询语法树
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.6" data-path="srcanaly/from.html">
            
                
                    <a href="../srcanaly/from.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.6.</b>
                        
                         FROM子句
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.1.6.1" data-path="srcanaly/sqlitefrom.html">
            
                
                    <a href="../srcanaly/sqlitefrom.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.6.1.</b>
                        
                         SQLite中FROM子句的使用
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.6.2" data-path="dir3/sqliteselectcolumnsfromexprlist.html">
            
                
                    <a href="../dir3/sqliteselectcolumnsfromexprlist.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.6.2.</b>
                        
                         SQLite中FROM子句的实现
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.1.7" data-path="dir3/articledir.html">
            
                
                    <a href="../dir3/articledir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.7.</b>
                        
                         ON子句
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.1.7.1" data-path="dir3/on.html">
            
                
                    <a href="../dir3/on.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.7.1.</b>
                        
                         SQLite中ON子句的使用
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.7.2" data-path="dir3/sqlitesqlite3jointypesetjoinexprsqliteprocessjoin.html">
            
                
                    <a href="../dir3/sqlitesqlite3jointypesetjoinexprsqliteprocessjoin.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.7.2.</b>
                        
                         SQLite中ON子句的实现
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.1.8" data-path="authc/README.html">
            
                
                    <a href="../authc/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.</b>
                        
                         访问授权
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.1.8.1" data-path="srcanaly/authorization.html">
            
                
                    <a href="../srcanaly/authorization.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.1.</b>
                        
                         SQLite的授权检查实现
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.8.2" data-path="authc/set.html">
            
                
                    <a href="../authc/set.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.2.</b>
                        
                         设置或清除访问授权
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.8.3" data-path="authc/authbadreturncode.html">
            
                
                    <a href="../authc/authbadreturncode.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.3.</b>
                        
                         授权返回一个非法的值
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.8.4" data-path="authc/authreadcol.html">
            
                
                    <a href="../authc/authreadcol.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.4.</b>
                        
                         验证数据库中表的列信息是否可访问
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.8.5" data-path="authc/tk_column.html">
            
                
                    <a href="../authc/tk_column.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.5.</b>
                        
                         验证解析树中TK_COLUMN表达式是否可访问
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.8.6" data-path="authc/authcheck.html">
            
                
                    <a href="../authc/authcheck.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.6.</b>
                        
                         使用给定的代码和参数的授权检查
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.1.8.7" data-path="authc/authcontext.html">
            
                
                    <a href="../authc/authcontext.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.1.8.7.</b>
                        
                         利用栈存储解析树的授权内容
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.2" data-path="dir3/selectsourcedir.html">
            
                
                    <a href="../dir3/selectsourcedir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.</b>
                        
                         查询重写
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.1" data-path="dir3/rewritefunction.html">
            
                
                    <a href="../dir3/rewritefunction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.1.</b>
                        
                         重写器的主要功能
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.2" data-path="optimalandquery/optimalquery.html">
            
                
                    <a href="../optimalandquery/optimalquery.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.2.</b>
                        
                         SQLite查询重写
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.2.1" data-path="optimalandquery/transcation.html">
            
                
                    <a href="../optimalandquery/transcation.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.2.1.</b>
                        
                         几类查询重写
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.2.2" data-path="optimalandquery/compress.html">
            
                
                    <a href="../optimalandquery/compress.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.2.2.</b>
                        
                         子查询扁平化
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.2.3" data-path="optimalandquery/link.html">
            
                
                    <a href="../optimalandquery/link.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.2.3.</b>
                        
                         连接查询
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.2.3" data-path="dir3/wheredir.html">
            
                
                    <a href="../dir3/wheredir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.3.</b>
                        
                         WHERE子句
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.3.1" data-path="dir3/where.html">
            
                
                    <a href="../dir3/where.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.3.1.</b>
                        
                         WHERE子句具体使用
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.3.2" data-path="dir3/sqliteaddwheretermselectinnerloop.html">
            
                
                    <a href="../dir3/sqliteaddwheretermselectinnerloop.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.3.2.</b>
                        
                         SQLite中使用addWhereTerm函数和selectInnerLoop函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.2.4" data-path="dir3/group_bydir.html">
            
                
                    <a href="../dir3/group_bydir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.4.</b>
                        
                         GROUP BY子句
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.4.1" data-path="dir3/group.html">
            
                
                    <a href="../dir3/group.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.4.1.</b>
                        
                         GROUP子句具体使用
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.4.2" data-path="dir3/sqlitefinalizeaggfunctions.html">
            
                
                    <a href="../dir3/sqlitefinalizeaggfunctions.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.4.2.</b>
                        
                         SQLite中finalizeAggFunctions函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.2.5" data-path="dir3/havingdir.html">
            
                
                    <a href="../dir3/havingdir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.5.</b>
                        
                         Having子句
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.6" data-path="dir3/distinctdir.html">
            
                
                    <a href="../dir3/distinctdir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.6.</b>
                        
                         DISTINCT子句
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.6.1" data-path="dir3/361____alldistinct.html">
            
                
                    <a href="../dir3/361____alldistinct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.6.1.</b>
                        
                         all和distinct子句
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.6.2" data-path="dir3/codedistinct.html">
            
                
                    <a href="../dir3/codedistinct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.6.2.</b>
                        
                         codeDistinct函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.2.7" data-path="dir3/order_bydir.html">
            
                
                    <a href="../dir3/order_bydir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.7.</b>
                        
                         ORDER BY子句
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.7.1" data-path="dir3/order_by.html">
            
                
                    <a href="../dir3/order_by.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.7.1.</b>
                        
                         ORDER BY子句具体应用
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.7.2" data-path="dir3/sqlitemultiselectorderby.html">
            
                
                    <a href="../dir3/sqlitemultiselectorderby.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.7.2.</b>
                        
                         SQLite中multiSelectOrderBy函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.2.8" data-path="dir3/limitdir.html">
            
                
                    <a href="../dir3/limitdir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.8.</b>
                        
                         LIMIT子句
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.8.1" data-path="dir3/sqlitecomputelimitregisters.html">
            
                
                    <a href="../dir3/sqlitecomputelimitregisters.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.8.1.</b>
                        
                         SQLite中computeLimitRegisters函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.2.9" data-path="dir3/offsetdir.html">
            
                
                    <a href="../dir3/offsetdir.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.9.</b>
                        
                         OFFSET子句
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.10" data-path="dir3/other.html">
            
                
                    <a href="../dir3/other.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.10.</b>
                        
                         另外一些重要的函数
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.2.10.1" data-path="dir3/sqlite3selectprep.html">
            
                
                    <a href="../dir3/sqlite3selectprep.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.10.1.</b>
                        
                         sqlite3SelectPrep函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.10.2" data-path="dir3/sqlite3getvdbe.html">
            
                
                    <a href="../dir3/sqlite3getvdbe.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.10.2.</b>
                        
                         sqlite3GetVdbe函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.2.10.3" data-path="dir3/minmaxquery.html">
            
                
                    <a href="../dir3/minmaxquery.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.2.10.3.</b>
                        
                         minMaxQuery函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.3" data-path="queryoptiintro/queryoptiintro.html">
            
                
                    <a href="../queryoptiintro/queryoptiintro.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.</b>
                        
                         查询优化器
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.3.1" data-path="queryoptiintro/queryoptiflow.html">
            
                
                    <a href="../queryoptiintro/queryoptiflow.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.1.</b>
                        
                         查询优化流程
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.2" data-path="queryoptiintro/queryoptiop.html">
            
                
                    <a href="../queryoptiintro/queryoptiop.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.2.</b>
                        
                         SQLite中几种查询优化做的处理
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.3" data-path="queryoptiintro/queryoptistrategy.html">
            
                
                    <a href="../queryoptiintro/queryoptistrategy.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.3.</b>
                        
                         查询扫描策略
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.4" data-path="queryoptiintro/costmodule.html">
            
                
                    <a href="../queryoptiintro/costmodule.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.4.</b>
                        
                         查询策略代价模型及计算方式
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5" data-path="analyzeanalyzec/README.html">
            
                
                    <a href="../analyzeanalyzec/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.</b>
                        
                         与查询代价有关的处理-ANALYZE命令
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.3.5.1" data-path="analyzeanalyzec/analyzesql.html">
            
                
                    <a href="../analyzeanalyzec/analyzesql.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.1.</b>
                        
                         Analyze的SQL语法
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5.2" data-path="analyzeanalyzec/analyze.html">
            
                
                    <a href="../analyzeanalyzec/analyze.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.2.</b>
                        
                         Analyze 命令接口
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5.3" data-path="analyzeanalyzec/analyzedatabase.html">
            
                
                    <a href="../analyzeanalyzec/analyzedatabase.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.3.</b>
                        
                         analyzeDatabase函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5.4" data-path="analyzeanalyzec/analyzetable.html">
            
                
                    <a href="../analyzeanalyzec/analyzetable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.4.</b>
                        
                         analyzeTable函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5.5" data-path="analyzeanalyzec/loadanalysis.html">
            
                
                    <a href="../analyzeanalyzec/loadanalysis.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.5.</b>
                        
                         loadAnalysis函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5.6" data-path="analyzeanalyzec/analyzeonetable.html">
            
                
                    <a href="../analyzeanalyzec/analyzeonetable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.6.</b>
                        
                         analyzeOneTable函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5.7" data-path="analyzeanalyzec/stat3initstat3pushstat3get.html">
            
                
                    <a href="../analyzeanalyzec/stat3initstat3pushstat3get.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.7.</b>
                        
                         stat3Init函数，stat3Push函数，stat3Get函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.5.8" data-path="analyzeanalyzec/other.html">
            
                
                    <a href="../analyzeanalyzec/other.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.5.8.</b>
                        
                         其他用到的一些函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6" data-path="wherec/README.html">
            
                
                    <a href="../wherec/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.</b>
                        
                         SQLite中查询优化的具体实现
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.3.6.1" data-path="wherec/sqlite3wherebegin.html">
            
                
                    <a href="../wherec/sqlite3wherebegin.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.1.</b>
                        
                         sqlite3WhereBegin函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6.2" data-path="wherec/expranalyzeall.html">
            
                
                    <a href="../wherec/expranalyzeall.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.2.</b>
                        
                         exprAnalyzeAll函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6.3" data-path="wherec/expranalyze.html">
            
                
                    <a href="../wherec/expranalyze.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.3.</b>
                        
                         exprAnalyze函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6.4" data-path="wherec/bestbtreeindex.html">
            
                
                    <a href="../wherec/bestbtreeindex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.4.</b>
                        
                         bestBtreeIndex函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6.5" data-path="wherec/bestorclauseindex.html">
            
                
                    <a href="../wherec/bestorclauseindex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.5.</b>
                        
                         bestOrClauseIndex函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6.6" data-path="wherec/whererangescanest.html">
            
                
                    <a href="../wherec/whererangescanest.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.6.</b>
                        
                         whereRangeScanEst函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6.7" data-path="wherec/codeoneloopstart.html">
            
                
                    <a href="../wherec/codeoneloopstart.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.7.</b>
                        
                         codeOneLoopStart函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.6.8" data-path="wherec/sqlite3whereend.html">
            
                
                    <a href="../wherec/sqlite3whereend.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.6.8.</b>
                        
                         sqlite3WhereEnd函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7" data-path="wherec/wherec.html">
            
                
                    <a href="../wherec/wherec.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.</b>
                        
                         where.c概述
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.3.7.1" data-path="wherec/wherecInfo/wherecprocess.html">
            
                
                    <a href="../wherec/wherecInfo/wherecprocess.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.1.</b>
                        
                         where.c的执行过程
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.2" data-path="wherec/wherecInfo/structandfunc.html">
            
                
                    <a href="../wherec/wherecInfo/structandfunc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.2.</b>
                        
                         where.c中主要结构体和函数调用关系
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.3.7.2.1" data-path="wherec/wherecInfo/struct.html">
            
                
                    <a href="../wherec/wherecInfo/struct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.2.1.</b>
                        
                         主要结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.2.2" data-path="wherec/wherecInfo/func.html">
            
                
                    <a href="../wherec/wherecInfo/func.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.2.2.</b>
                        
                         主要函数调用关系
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3" data-path="wherec/where.html">
            
                
                    <a href="../wherec/where.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.</b>
                        
                         where子句的查询优化
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.3.7.3.1" data-path="wherec/whereOptimize/whereanalyze.html">
            
                
                    <a href="../wherec/whereOptimize/whereanalyze.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.1.</b>
                        
                         WHERE子句分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3.2" data-path="wherec/whereOptimize/between.html">
            
                
                    <a href="../wherec/whereOptimize/between.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.2.</b>
                        
                         BETWEEN语句优化
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3.3" data-path="wherec/whereOptimize/or.html">
            
                
                    <a href="../wherec/whereOptimize/or.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.3.</b>
                        
                         OR语句优化
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3.4" data-path="wherec/whereOptimize/like.html">
            
                
                    <a href="../wherec/whereOptimize/like.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.4.</b>
                        
                         LIKE语句优化
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3.5" data-path="wherec/whereOptimize/skip-scan.html">
            
                
                    <a href="../wherec/whereOptimize/skip-scan.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.5.</b>
                        
                         Skip-Scan优化
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3.6" data-path="wherec/whereOptimize/selmultindex.html">
            
                
                    <a href="../wherec/whereOptimize/selmultindex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.6.</b>
                        
                         多重索引的选择
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3.7" data-path="wherec/whereOptimize/coverindex.html">
            
                
                    <a href="../wherec/whereOptimize/coverindex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.7.</b>
                        
                         覆盖索引
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.3.8" data-path="wherec/whereOptimize/autoindex.html">
            
                
                    <a href="../wherec/whereOptimize/autoindex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.3.8.</b>
                        
                         自动索引
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.3.7.4" data-path="wherec/wherecsummary.html">
            
                
                    <a href="../wherec/wherecsummary.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.7.4.</b>
                        
                         wherecSummary
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.3.8" data-path="queryoptiintro/queryoptisummary.html">
            
                
                    <a href="../queryoptiintro/queryoptisummary.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.3.8.</b>
                        
                         SQLite中查询优化方式的总结
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4" data-path="dir2/introduction.html">
            
                
                    <a href="../dir2/introduction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.</b>
                        
                         查询执行器
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.1" data-path="dir2/dataalter.html">
            
                
                    <a href="../dir2/dataalter.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.1.</b>
                        
                         数据修改语句
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2" data-path="buildc/buildcsqlite.html">
            
                
                    <a href="../buildc/buildcsqlite.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.</b>
                        
                         Build.c分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.2.1" data-path="buildc/function.html">
            
                
                    <a href="../buildc/function.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.1.</b>
                        
                         实现的功能
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2" data-path="function/achieve.html">
            
                
                    <a href="../function/achieve.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.</b>
                        
                         具体功能的实现
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.2.2.1" data-path="function/createtable.html">
            
                
                    <a href="../function/createtable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.1.</b>
                        
                         表的创建
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.2" data-path="function/del.html">
            
                
                    <a href="../function/del.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.2.</b>
                        
                         表的删除
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.3" data-path="function/othertable.html">
            
                
                    <a href="../function/othertable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.3.</b>
                        
                         与表相关的操作
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.4" data-path="function/createView.html">
            
                
                    <a href="../function/createView.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.4.</b>
                        
                         视图的创建
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.5" data-path="index/create.html">
            
                
                    <a href="../index/create.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.5.</b>
                        
                         索引的创建
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.6" data-path="index/select.html">
            
                
                    <a href="../index/select.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.6.</b>
                        
                         索引的删除
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.7" data-path="index/free.html">
            
                
                    <a href="../index/free.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.7.</b>
                        
                         释放索引（与删除索引相关）
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.8" data-path="index/other.html">
            
                
                    <a href="../index/other.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.8.</b>
                        
                         与索引相关的其他操作
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.9" data-path="id/idcreate.html">
            
                
                    <a href="../id/idcreate.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.9.</b>
                        
                         ID序列的创建
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.10" data-path="id/idselect.html">
            
                
                    <a href="../id/idselect.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.10.</b>
                        
                         ID序列的删除
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.11" data-path="id/idother.html">
            
                
                    <a href="../id/idother.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.11.</b>
                        
                         ID序列其他操作
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.12" data-path="routine/routinestart.html">
            
                
                    <a href="../routine/routinestart.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.12.</b>
                        
                         事务的开始
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.13" data-path="routine/routinesubmit.html">
            
                
                    <a href="../routine/routinesubmit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.13.</b>
                        
                         事务的提交
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.14" data-path="routine/routinerollback.html">
            
                
                    <a href="../routine/routinerollback.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.14.</b>
                        
                         事务的回滚
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.15" data-path="function/temporarydb.html">
            
                
                    <a href="../function/temporarydb.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.15.</b>
                        
                         临时数据库
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.16" data-path="function/write.html">
            
                
                    <a href="../function/write.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.16.</b>
                        
                         写操作
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.2.2.17" data-path="function/exception.html">
            
                
                    <a href="../function/exception.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.2.2.17.</b>
                        
                         异常检查
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3" data-path="insertc/README.html">
            
                
                    <a href="../insertc/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.</b>
                        
                         Insert.c解析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.3.1" data-path="insertc/insert.html">
            
                
                    <a href="../insertc/insert.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.1.</b>
                        
                         insert的主要关系
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.2" data-path="insertc/sqlite3opentable.html">
            
                
                    <a href="../insertc/sqlite3opentable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.2.</b>
                        
                         sqlite3OpenTable()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.3" data-path="insertc/sqlite3indexaffinitystr.html">
            
                
                    <a href="../insertc/sqlite3indexaffinitystr.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.3.</b>
                        
                         sqlite3IndexAffinityStr()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.4" data-path="insertc/sqlite3tableaffinitystr.html">
            
                
                    <a href="../insertc/sqlite3tableaffinitystr.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.4.</b>
                        
                         sqlite3TableAffinityStr()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.5" data-path="insertc/static_int_readstable.html">
            
                
                    <a href="../insertc/static_int_readstable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.5.</b>
                        
                         static int readsTable()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.6" data-path="insertc/static_int_autoincbegin.html">
            
                
                    <a href="../insertc/static_int_autoincbegin.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.6.</b>
                        
                         static int autoIncBegin()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.7" data-path="insertc/void_sqlite3autoincrementbegin.html">
            
                
                    <a href="../insertc/void_sqlite3autoincrementbegin.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.7.</b>
                        
                         void sqlite3AutoincrementBegin()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.8" data-path="insertc/static_void_autoincstep.html">
            
                
                    <a href="../insertc/static_void_autoincstep.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.8.</b>
                        
                         static void autoIncStep()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.9" data-path="insertc/sqlite3autoincrementend.html">
            
                
                    <a href="../insertc/sqlite3autoincrementend.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.9.</b>
                        
                         sqlite3AutoincrementEnd()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.10" data-path="insertc/xferoptimization.html">
            
                
                    <a href="../insertc/xferoptimization.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.10.</b>
                        
                         xferOptimization()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.11" data-path="insertc/sqlite3insert.html">
            
                
                    <a href="../insertc/sqlite3insert.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.11.</b>
                        
                         sqlite3Insert()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.12" data-path="insertc/sqlite3generateconstraintchecks.html">
            
                
                    <a href="../insertc/sqlite3generateconstraintchecks.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.12.</b>
                        
                         sqlite3GenerateConstraintChecks()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.13" data-path="insertc/sqlite3completeinsertion.html">
            
                
                    <a href="../insertc/sqlite3completeinsertion.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.13.</b>
                        
                         sqlite3CompleteInsertion()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.14" data-path="insertc/sqlite3opentableandindices.html">
            
                
                    <a href="../insertc/sqlite3opentableandindices.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.14.</b>
                        
                         sqlite3OpenTableAndIndices()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.15" data-path="insertc/xfercompatiblecollation.html">
            
                
                    <a href="../insertc/xfercompatiblecollation.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.15.</b>
                        
                         xferCompatibleCollation()
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.3.16" data-path="insertc/xfercompatibleindex.html">
            
                
                    <a href="../insertc/xfercompatibleindex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.3.16.</b>
                        
                         xferCompatibleIndex()
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4" data-path="deletecupdatec/READMEG22.html">
            
                
                    <a href="../deletecupdatec/READMEG22.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.</b>
                        
                         分析delete.c和update.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.4.1" data-path="deletecupdatec/cast.html">
            
                
                    <a href="../deletecupdatec/cast.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.1.</b>
                        
                         CAST函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4.2" data-path="deletecupdatec/escape.html">
            
                
                    <a href="../deletecupdatec/escape.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.2.</b>
                        
                         ESCAPE
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4.3" data-path="deletecupdatec/likeglob.html">
            
                
                    <a href="../deletecupdatec/likeglob.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.3.</b>
                        
                         Like和Glob
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4.4" data-path="deletecupdatec/isnull.html">
            
                
                    <a href="../deletecupdatec/isnull.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.4.</b>
                        
                         ISNULL
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4.5" data-path="deletecupdatec/between.html">
            
                
                    <a href="../deletecupdatec/between.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.5.</b>
                        
                         between
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4.6" data-path="deletecupdatec/exist.html">
            
                
                    <a href="../deletecupdatec/exist.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.6.</b>
                        
                         EXISTS
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4.7" data-path="deletecupdatec/case_when.html">
            
                
                    <a href="../deletecupdatec/case_when.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.7.</b>
                        
                         case when
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.4.8" data-path="deletecupdatec/raise.html">
            
                
                    <a href="../deletecupdatec/raise.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.4.8.</b>
                        
                         RAISE()函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5" data-path="deletecupdatec/delete.html">
            
                
                    <a href="../deletecupdatec/delete.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.</b>
                        
                         Delete.c中主要函数的实现及功能
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.5.1" data-path="deletecupdatec/sqlite3srclistlookup.html">
            
                
                    <a href="../deletecupdatec/sqlite3srclistlookup.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.1.</b>
                        
                         sqlite3SrcListLookup()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5.2" data-path="deletecupdatec/sqlite3isreadonly.html">
            
                
                    <a href="../deletecupdatec/sqlite3isreadonly.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.2.</b>
                        
                         sqlite3IsReadOnly()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5.3" data-path="deletecupdatec/sqlite3materializeview.html">
            
                
                    <a href="../deletecupdatec/sqlite3materializeview.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.3.</b>
                        
                         sqlite3MaterializeView()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5.4" data-path="deletecupdatec/sqlite3limitwhere.html">
            
                
                    <a href="../deletecupdatec/sqlite3limitwhere.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.4.</b>
                        
                         sqlite3LimitWhere()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5.5" data-path="deletecupdatec/sqlite3deletefrom.html">
            
                
                    <a href="../deletecupdatec/sqlite3deletefrom.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.5.</b>
                        
                         sqlite3DeleteFrom()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5.6" data-path="deletecupdatec/sqlite3generaterowdelete.html">
            
                
                    <a href="../deletecupdatec/sqlite3generaterowdelete.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.6.</b>
                        
                         sqlite3GenerateRowDelete()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5.7" data-path="deletecupdatec/sqlite3generaterowindexdelete.html">
            
                
                    <a href="../deletecupdatec/sqlite3generaterowindexdelete.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.7.</b>
                        
                         sqlite3GenerateRowIndexDelete()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.5.8" data-path="deletecupdatec/sqlite3generateindexkey.html">
            
                
                    <a href="../deletecupdatec/sqlite3generateindexkey.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.5.8.</b>
                        
                         sqlite3GenerateIndexKey()函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6" data-path="updatec/updatec.html">
            
                
                    <a href="../updatec/updatec.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.</b>
                        
                         Update.c简介
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.6.1" data-path="updatec/sqlite3columndefault.html">
            
                
                    <a href="../updatec/sqlite3columndefault.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.1.</b>
                        
                         sqlite3ColumnDefault函数说明
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.2" data-path="updatec/sqlite3columndefault1.html">
            
                
                    <a href="../updatec/sqlite3columndefault1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.2.</b>
                        
                         sqlite3ColumnDefault函数结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.3" data-path="updatec/sqlite3columndefault2.html">
            
                
                    <a href="../updatec/sqlite3columndefault2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.3.</b>
                        
                         函数流程图
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.4" data-path="updatec/updatecsuhssm.html">
            
                
                    <a href="../updatec/updatecsuhssm.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.4.</b>
                        
                         sqlite3Update函数说明
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.5" data-path="updatec/updatecsuhsjg.html">
            
                
                    <a href="../updatec/updatecsuhsjg.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.5.</b>
                        
                         sqlite3Update函数结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.6" data-path="updatec/updatecsuhslct.html">
            
                
                    <a href="../updatec/updatecsuhslct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.6.</b>
                        
                         sqlite3Update函数流程图
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.7" data-path="updatec/updatecuphssm.html">
            
                
                    <a href="../updatec/updatecuphssm.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.7.</b>
                        
                         updateVirtualtable函数说明
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.8" data-path="updatec/updatevirtualtable.html">
            
                
                    <a href="../updatec/updatevirtualtable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.8.</b>
                        
                         updateVirtualtable函数结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.6.9" data-path="updatec/updatecuvhslct.html">
            
                
                    <a href="../updatec/updatecuvhslct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.6.9.</b>
                        
                         updateVirtualtable函数流程图
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4.7" data-path="deletecupdatec/update.html">
            
                
                    <a href="../deletecupdatec/update.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.7.</b>
                        
                         Update.c中主要函数的实现及功能
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.7.1" data-path="deletecupdatec/sqlite3columndefault.html">
            
                
                    <a href="../deletecupdatec/sqlite3columndefault.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.7.1.</b>
                        
                         sqlite3ColumnDefault()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.7.2" data-path="deletecupdatec/sqlite3update.html">
            
                
                    <a href="../deletecupdatec/sqlite3update.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.7.2.</b>
                        
                         sqlite3Update()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.7.3" data-path="deletecupdatec/updatevirtualtable.html">
            
                
                    <a href="../deletecupdatec/updatevirtualtable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.7.3.</b>
                        
                         updateVirtualTable()函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4.8" data-path="triggerc/triggerjj.html">
            
                
                    <a href="../triggerc/triggerjj.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.8.</b>
                        
                         Trigger.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.8.1" data-path="triggerc/jbyf.html">
            
                
                    <a href="../triggerc/jbyf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.8.1.</b>
                        
                         基本语法
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.8.2" data-path="triggerc/hsjs.html">
            
                
                    <a href="../triggerc/hsjs.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.8.2.</b>
                        
                         函数介绍
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.8.3" data-path="triggerc/cfqmm.html">
            
                
                    <a href="../triggerc/cfqmm.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.8.3.</b>
                        
                         触发器编码（Code）
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.8.4" data-path="triggerc/triggerssssdfsd.html">
            
                
                    <a href="../triggerc/triggerssssdfsd.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.8.4.</b>
                        
                         sqlite3BeginTrigger和sqlite3FinishTrigger
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.8.5" data-path="triggerc/triggerstep.html">
            
                
                    <a href="../triggerc/triggerstep.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.8.5.</b>
                        
                         Step
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9" data-path="alter_tablealterc/README.html">
            
                
                    <a href="../alter_tablealterc/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.</b>
                        
                         实现修改表功能ALTER TABLE（alter.c的源码分析）
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.4.9.1" data-path="alter_tablealterc/renametablefunc.html">
            
                
                    <a href="../alter_tablealterc/renametablefunc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.1.</b>
                        
                         重命名表的名称
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9.2" data-path="alter_tablealterc/renameparentfunc.html">
            
                
                    <a href="../alter_tablealterc/renameparentfunc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.2.</b>
                        
                         修改任何外键约束定义重命名表为父表
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9.3" data-path="alter_tablealterc/renametriggerfunc.html">
            
                
                    <a href="../alter_tablealterc/renametriggerfunc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.3.</b>
                        
                         对触发器的表名做修改
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9.4" data-path="alter_tablealterc/whereorname.html">
            
                
                    <a href="../alter_tablealterc/whereorname.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.4.</b>
                        
                         创建表达式形式的文本
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9.5" data-path="alter_tablealterc/whereforeignkeys.html">
            
                
                    <a href="../alter_tablealterc/whereforeignkeys.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.5.</b>
                        
                         生成用来选择有外键约束的全部表的表达式文本
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9.6" data-path="alter_tablealterc/ptab.html">
            
                
                    <a href="../alter_tablealterc/ptab.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.6.</b>
                        
                         删除和重新加载从数据库表pTab的内部模式
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9.7" data-path="alter_tablealterc/issystemtable.html">
            
                
                    <a href="../alter_tablealterc/issystemtable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.7.</b>
                        
                         判断一个系统表
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.4.9.8" data-path="alter_tablealterc/alterrenametable.html">
            
                
                    <a href="../alter_tablealterc/alterrenametable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.4.9.8.</b>
                        
                         删除表名并重命名为新表名
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.5" data-path="dir2/selectinit.html">
            
                
                    <a href="../dir2/selectinit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.5.</b>
                        
                         生成，清空，删除SELECT查询树函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6" data-path="queryoptiintro/sqlite.html">
            
                
                    <a href="../queryoptiintro/sqlite.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.</b>
                        
                         数据库扩展性
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.1" data-path="queryoptiintro/virtualtable.html">
            
                
                    <a href="../queryoptiintro/virtualtable.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.1.</b>
                        
                         virtualtable虚表
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.2" data-path="utf.c&amp;vacuum/vacuum.html">
            
                
                    <a href="../utf.c&amp;vacuum/vacuum.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.2.</b>
                        
                         vacuum.c分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.3" data-path="loadextclegacyc/README.html">
            
                
                    <a href="../loadextclegacyc/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.3.</b>
                        
                         Loadext及clegacy.c文件解析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.4" data-path="rtree/gs.html">
            
                
                    <a href="../rtree/gs.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.4.</b>
                        
                         R-tree概述
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.5" data-path="rtree/usertree.html">
            
                
                    <a href="../rtree/usertree.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.5.</b>
                        
                         使用Rtree模块
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.5.1" data-path="rtree/creatertree.html">
            
                
                    <a href="../rtree/creatertree.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.5.1.</b>
                        
                         创建一个Rtree索引
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.5.2" data-path="rtree/getrtree.html">
            
                
                    <a href="../rtree/getrtree.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.5.2.</b>
                        
                         获取一个Rtree索引
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.5.3" data-path="rtree/queryrtree.html">
            
                
                    <a href="../rtree/queryrtree.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.5.3.</b>
                        
                         查询一个Rtree索引
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.6.6" data-path="rtree/efficientuse.html">
            
                
                    <a href="../rtree/efficientuse.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.6.</b>
                        
                         有效使用Rtree
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.7" data-path="rtree/tailorrtree.html">
            
                
                    <a href="../rtree/tailorrtree.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.7.</b>
                        
                         定制R树查询
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.7.1" data-path="rtree/xgeom.html">
            
                
                    <a href="../rtree/xgeom.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.7.1.</b>
                        
                         旧版本xGeom回调函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.7.2" data-path="rtree/xqueryfunc.html">
            
                
                    <a href="../rtree/xqueryfunc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.7.2.</b>
                        
                         全新xQueryFunc回调函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.7.3" data-path="rtree/tailorCare.html">
            
                
                    <a href="../rtree/tailorCare.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.7.3.</b>
                        
                         定制查询注意事项
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.6.8" data-path="rtree/READMEStruct.html">
            
                
                    <a href="../rtree/READMEStruct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.8.</b>
                        
                         SQLiteR树结构
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.8.1" data-path="rtree/NodeStruct.html">
            
                
                    <a href="../rtree/NodeStruct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.8.1.</b>
                        
                         结点结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.8.2" data-path="rtree/CellStruct.html">
            
                
                    <a href="../rtree/CellStruct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.8.2.</b>
                        
                         结点单元结构
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.6.9" data-path="rtree/READMEImpention.html">
            
                
                    <a href="../rtree/READMEImpention.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.9.</b>
                        
                         R树特点及算法实现
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.9.1" data-path="rtree/Searing.html">
            
                
                    <a href="../rtree/Searing.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.9.1.</b>
                        
                         查找
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.9.2" data-path="rtree/Insertion.html">
            
                
                    <a href="../rtree/Insertion.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.9.2.</b>
                        
                         插入
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.9.3" data-path="rtree/Deletion.html">
            
                
                    <a href="../rtree/Deletion.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.9.3.</b>
                        
                         删除
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.9.4" data-path="rtree/Update.html">
            
                
                    <a href="../rtree/Update.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.9.4.</b>
                        
                         更新
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.9.5" data-path="rtree/QSplit.html">
            
                
                    <a href="../rtree/QSplit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.9.5.</b>
                        
                         平方分裂
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.9.6" data-path="rtree/LinearSplit.html">
            
                
                    <a href="../rtree/LinearSplit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.9.6.</b>
                        
                         线性分裂
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.6.10" data-path="rtree/READMEOptimize.html">
            
                
                    <a href="../rtree/READMEOptimize.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.10.</b>
                        
                         R*树优化
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.10.1" data-path="rtree/local.html">
            
                
                    <a href="../rtree/local.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.10.1.</b>
                        
                         局部优化
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.10.2" data-path="rtree/all.html">
            
                
                    <a href="../rtree/all.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.10.2.</b>
                        
                         整体优化
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.6.11" data-path="fts1/cjcode.html">
            
                
                    <a href="../fts1/cjcode.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.11.</b>
                        
                         全文索引
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.12" data-path="fts1/fts.html">
            
                
                    <a href="../fts1/fts.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.12.</b>
                        
                         全文检索(full-text search)
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.12.1" data-path="fts1/indexO.html">
            
                
                    <a href="../fts1/indexO.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.12.1.</b>
                        
                         索引的组织结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.12.2" data-path="fts1/indexC.html">
            
                
                    <a href="../fts1/indexC.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.12.2.</b>
                        
                         索引的创建
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.12.3" data-path="fts1/search.html">
            
                
                    <a href="../fts1/search.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.12.3.</b>
                        
                         索引的搜索
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.6.13" data-path="lemon/README.html">
            
                
                    <a href="../lemon/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.13.</b>
                        
                         Lemon语法分析器模板文件
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.14" data-path="sqlite/sqliteG2.html">
            
                
                    <a href="../sqlite/sqliteG2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.14.</b>
                        
                         分词器
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.14.1" data-path="sqlite/tokenizer.html">
            
                
                    <a href="../sqlite/tokenizer.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.14.1.</b>
                        
                         Tokenizer运行原理
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.14.2" data-path="sqlite/code.html">
            
                
                    <a href="../sqlite/code.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.14.2.</b>
                        
                         代码code发生器 
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.14.3" data-path="sqlite/fts3.html">
            
                
                    <a href="../sqlite/fts3.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.14.3.</b>
                        
                         FTS3概述
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.14.4" data-path="sqlite/fts_tokenizer.html">
            
                
                    <a href="../sqlite/fts_tokenizer.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.14.4.</b>
                        
                         分词器：FTS tokenizer分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.14.5" data-path="sqlite/16____tokenizers.html">
            
                
                    <a href="../sqlite/16____tokenizers.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.14.5.</b>
                        
                         自定义(用户)实现tokenizers
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15" data-path="fts3_exprc/fts3.html">
            
                
                    <a href="../fts3_exprc/fts3.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.</b>
                        
                         FTS3
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="4.6.15.1" data-path="fts3_exprc/fts3_exprcdoc.html">
            
                
                    <a href="../fts3_exprc/fts3_exprcdoc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.1.</b>
                        
                         fts3_expr简介
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15.2" data-path="fts3_exprc/parsecontext.html">
            
                
                    <a href="../fts3_exprc/parsecontext.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.2.</b>
                        
                         ParseContext结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15.3" data-path="fts3_exprc/getnexttoken.html">
            
                
                    <a href="../fts3_exprc/getnexttoken.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.3.</b>
                        
                         getNextToken()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15.4" data-path="fts3_exprc/getnextstring.html">
            
                
                    <a href="../fts3_exprc/getnextstring.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.4.</b>
                        
                         getNextString()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15.5" data-path="fts3_exprc/getnextnode.html">
            
                
                    <a href="../fts3_exprc/getnextnode.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.5.</b>
                        
                         getNextNode()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15.6" data-path="fts3_exprc/insertbinaryoperator.html">
            
                
                    <a href="../fts3_exprc/insertbinaryoperator.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.6.</b>
                        
                         insertBinaryOperator()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15.7" data-path="fts3_exprc/fts3exprparse.html">
            
                
                    <a href="../fts3_exprc/fts3exprparse.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.7.</b>
                        
                         fts3ExprParse()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.6.15.8" data-path="fts3_exprc/sqlite3fts3exprparse.html">
            
                
                    <a href="../fts3_exprc/sqlite3fts3exprparse.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.6.15.8.</b>
                        
                         sqlite3Fts3ExprParse()函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="4.7" data-path="optimalandquery/query.html">
            
                
                    <a href="../optimalandquery/query.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.7.</b>
                        
                         在SQLite3下查询数据
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="4.8" data-path="srcAnaly/otherFunc.html">
            
                
                    <a href="../srcAnaly/otherFunc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>4.8.</b>
                        
                         其它一些函数的功能
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5" data-path="summary/READMEG1.html">
            
                
                    <a href="../summary/READMEG1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.</b>
                        
                         存储管理
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.1" data-path="summary/spacecontrol.html">
            
                
                    <a href="../summary/spacecontrol.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.</b>
                        
                         文件系统
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.1.1" data-path="functionandstructbody/analysis.html">
            
                
                    <a href="../functionandstructbody/analysis.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.1.</b>
                        
                         文件函数及结构体分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.1.2" data-path="third/fenxi.html">
            
                
                    <a href="../third/fenxi.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.</b>
                        
                         系统接口
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.1.2.1" data-path="third/xjklc.html">
            
                
                    <a href="../third/xjklc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.1.</b>
                        
                         简析打开数据库流程
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.1.2.2" data-path="third/hsjg.html">
            
                
                    <a href="../third/hsjg.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.2.</b>
                        
                         简析os_win.c文件的函数结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.1.2.3" data-path="third/sjz.html">
            
                
                    <a href="../third/sjz.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.3.</b>
                        
                         简析SQLite的锁机制
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.1.2.4" data-path="third/sxlc.html">
            
                
                    <a href="../third/sxlc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.4.</b>
                        
                         SQLite在Windows系统上的锁机制实现流程
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.1.2.5" data-path="third/sxym.html">
            
                
                    <a href="../third/sxym.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.5.</b>
                        
                         锁机制在Windows中的实现源码
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.1.2.6" data-path="filestruct/introduction.html">
            
                
                    <a href="../filestruct/introduction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.6.</b>
                        
                         文件结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.1.2.7" data-path="functionmainimplement/introduction.html">
            
                
                    <a href="../functionmainimplement/introduction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.2.7.</b>
                        
                         功能的主要实现
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5.1.3" data-path="summary/filesysteminterface">
            
                
                    <a href="../summary/filesysteminterface">
                        <i class="fa fa-check"></i>
                        
                            <b>5.1.3.</b>
                        
                         filesysteminterface
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5.2" data-path="B-treeImplementation/introduction.html">
            
                
                    <a href="../B-treeImplementation/introduction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.2.</b>
                        
                         SQLite中B-tree的实现
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.2.1" data-path="B-treeImplementation/sqliteb-tree.html">
            
                
                    <a href="../B-treeImplementation/sqliteb-tree.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.2.1.</b>
                        
                         SQLite中的B-tree 
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.2.2" data-path="B-treeImplementation/hierarchicalorganization.html">
            
                
                    <a href="../B-treeImplementation/hierarchicalorganization.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.2.2.</b>
                        
                         SQLite层次化数据组织
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter active" data-level="5.2.3" data-path="B-treeImplementation/overflow.html">
            
                
                    <a href="../B-treeImplementation/overflow.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.2.3.</b>
                        
                         页面溢出
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.2.4" data-path="B-treeImplementation/b-tree_api.html">
            
                
                    <a href="../B-treeImplementation/b-tree_api.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.2.4.</b>
                        
                         B-tree API
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.2.5" data-path="B-treeImplementation/implement.html">
            
                
                    <a href="../B-treeImplementation/implement.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.2.5.</b>
                        
                         实现的技术细节
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5.3" data-path="ljPager/pager.html">
            
                
                    <a href="../ljPager/pager.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.</b>
                        
                         Pager概述
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.3.1" data-path="ljPager/21.html">
            
                
                    <a href="../ljPager/21.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.1.</b>
                        
                         Pager状态
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.2" data-path="ljPager/22.html">
            
                
                    <a href="../ljPager/22.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.2.</b>
                        
                         Pager的数据库文件页
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.3" data-path="ljPager/23.html">
            
                
                    <a href="../ljPager/23.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.3.</b>
                        
                         Pager的相关参数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.4" data-path="ljPager/24.html">
            
                
                    <a href="../ljPager/24.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.4.</b>
                        
                         页面类型
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.5" data-path="ljPager/25.html">
            
                
                    <a href="../ljPager/25.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.5.</b>
                        
                         Pager的状态
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.6" data-path="ljPager/26.html">
            
                
                    <a href="../ljPager/26.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.6.</b>
                        
                         Pager的结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.7" data-path="ljPager/27.html">
            
                
                    <a href="../ljPager/27.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.7.</b>
                        
                         日志
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.8" data-path="ljPager/28.html">
            
                
                    <a href="../ljPager/28.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.8.</b>
                        
                         页面缓存
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.3.9" data-path="ljPager/29.html">
            
                
                    <a href="../ljPager/29.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.3.9.</b>
                        
                         锁机制
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5.4" data-path="ljPager/sqlitepager.html">
            
                
                    <a href="../ljPager/sqlitepager.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.</b>
                        
                         Pager的运行流程概述
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.4.1" data-path="ljPager/31.html">
            
                
                    <a href="../ljPager/31.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.1.</b>
                        
                         打开/关闭一个页面连接
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.4.2" data-path="ljPager/32.html">
            
                
                    <a href="../ljPager/32.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.2.</b>
                        
                         配置页面对象的函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.4.3" data-path="ljPager/33.html">
            
                
                    <a href="../ljPager/33.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.3.</b>
                        
                         获取和释放页面引用的函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.4.4" data-path="ljPager/34.html">
            
                
                    <a href="../ljPager/34.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.4.</b>
                        
                         对页面引用的操作
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.4.5" data-path="ljPager/35.html">
            
                
                    <a href="../ljPager/35.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.5.</b>
                        
                         管理页面事务和保存点的函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.4.6" data-path="ljPager/36.html">
            
                
                    <a href="../ljPager/36.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.6.</b>
                        
                         查询页面状态/配置
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.4.7" data-path="ljPager/37.html">
            
                
                    <a href="../ljPager/37.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.7.</b>
                        
                         截断数据库文件
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.4.8" data-path="ljPager/38.html">
            
                
                    <a href="../ljPager/38.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.4.8.</b>
                        
                         测试/调试
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5.5" data-path="cache analysis/pager/pagecache.html">
            
                
                    <a href="../cache analysis/pager/pagecache.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.5.</b>
                        
                         页面缓冲管理
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.5.1" data-path="cache analysis/pager/cachemanage.html">
            
                
                    <a href="../cache analysis/pager/cachemanage.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.5.1.</b>
                        
                         缓存管理
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.5.2" data-path="cache analysis/pager/cacheorg.html">
            
                
                    <a href="../cache analysis/pager/cacheorg.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.5.2.</b>
                        
                         缓存组织
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5.6" data-path="cache analysis/pager/cache.html">
            
                
                    <a href="../cache analysis/pager/cache.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.6.</b>
                        
                         cache具体结构
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.6.1" data-path="cache analysis/pager/struct_pcachestruct_pcach1/pcahcevspcache1.html">
            
                
                    <a href="../cache analysis/pager/struct_pcachestruct_pcach1/pcahcevspcache1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.6.1.</b>
                        
                         Struct PCache与Struct PCach1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.6.2" data-path="cache analysis/pager/struct_pcache_vs_struct_pcache1/pghdrvspghdr1.html">
            
                
                    <a href="../cache analysis/pager/struct_pcache_vs_struct_pcache1/pghdrvspghdr1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.6.2.</b>
                        
                         Struct PCache VS Struct PCache1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.6.3" data-path="cache analysis/pager/struct_pghdr_1struct_pcache1/pghdr1andpcache1.html">
            
                
                    <a href="../cache analysis/pager/struct_pghdr_1struct_pcache1/pghdr1andpcache1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.6.3.</b>
                        
                         struct PgHdr 1与struct PCache1
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.6.4" data-path="cache analysis/pager/cache/cachestucture.html">
            
                
                    <a href="../cache analysis/pager/cache/cachestucture.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.6.4.</b>
                        
                         cache内存结构
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="5.6.5" data-path="cache analysis/pager/struct_pgroupstruct_pcacheglobal/pgroupandpcacheglobal.html">
            
                
                    <a href="../cache analysis/pager/struct_pgroupstruct_pcacheglobal/pgroupandpcacheglobal.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.6.5.</b>
                        
                         Struct PGroup与Struct PCacheGlobal
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="5.7" data-path="bit/bitvecintro.html">
            
                
                    <a href="../bit/bitvecintro.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.7.</b>
                        
                         Bitvec.c介绍
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="5.7.1" data-path="bit/achieve.html">
            
                
                    <a href="../bit/achieve.html">
                        <i class="fa fa-check"></i>
                        
                            <b>5.7.1.</b>
                        
                         具体实现及源码分析
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6" data-path="References/introduction.html">
            
                
                    <a href="../References/introduction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.</b>
                        
                         事务:并发控制和恢复
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.1" data-path="lockandimplement/introduction.html">
            
                
                    <a href="../lockandimplement/introduction.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.</b>
                        
                         SQLite不同模式的锁与实现
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.1.1" data-path="lockandimplement/machining.html">
            
                
                    <a href="../lockandimplement/machining.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.1.</b>
                        
                         SQLite锁机制简介
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.1.2" data-path="lockandimplement/method.html">
            
                
                    <a href="../lockandimplement/method.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.2.</b>
                        
                         文件加锁方法
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.1.2.1" data-path="lockandimplement/posix.html">
            
                
                    <a href="../lockandimplement/posix.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.2.1.</b>
                        
                         POSIX locking
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.1.2.2" data-path="lockandimplement/noop.html">
            
                
                    <a href="../lockandimplement/noop.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.2.2.</b>
                        
                         No-op Locking
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.1.2.3" data-path="lockandimplement/dotfile.html">
            
                
                    <a href="../lockandimplement/dotfile.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.2.3.</b>
                        
                         dot-file Locking
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.1.2.4" data-path="lockandimplement/flock.html">
            
                
                    <a href="../lockandimplement/flock.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.2.4.</b>
                        
                         flock Locking
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.1.2.5" data-path="lockandimplement/semaphore.html">
            
                
                    <a href="../lockandimplement/semaphore.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.2.5.</b>
                        
                         Named Semaphore Locking
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.1.2.6" data-path="lockandimplement/afp.html">
            
                
                    <a href="../lockandimplement/afp.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.2.6.</b>
                        
                         AFP Locking
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.1.3" data-path="lockandimplement/function.html">
            
                
                    <a href="../lockandimplement/function.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.1.3.</b>
                        
                         各个锁机制实现函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.2" data-path="part6/1.html">
            
                
                    <a href="../part6/1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.</b>
                        
                         SQlite互斥锁分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.1" data-path="part6/mutexh.html">
            
                
                    <a href="../part6/mutexh.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.1.</b>
                        
                         mutex.h
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.2" data-path="part6/mutexc.html">
            
                
                    <a href="../part6/mutexc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.2.</b>
                        
                         mutex.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.2.1" data-path="part6/mutex.html">
            
                
                    <a href="../part6/mutex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.2.1.</b>
                        
                         Mutex初始化
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.2.2" data-path="part6/enter.html">
            
                
                    <a href="../part6/enter.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.2.2.</b>
                        
                         互斥体enter使用
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.2.3" data-path="part6/try.html">
            
                
                    <a href="../part6/try.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.2.3.</b>
                        
                         互斥体try使用
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.2.3" data-path="part6/mutex_w32c.html">
            
                
                    <a href="../part6/mutex_w32c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.3.</b>
                        
                         Mutex_w32.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.3.1" data-path="part6/631.html">
            
                
                    <a href="../part6/631.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.3.1.</b>
                        
                         互斥锁结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.3.2" data-path="part6/632.html">
            
                
                    <a href="../part6/632.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.3.2.</b>
                        
                         设置结构体下的锁的函数指针
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.3.3" data-path="part6/633.html">
            
                
                    <a href="../part6/633.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.3.3.</b>
                        
                         初始化互斥锁
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.3.3.1" data-path="part6/6331.html">
            
                
                    <a href="../part6/6331.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.3.3.1.</b>
                        
                         互斥锁结构体分配
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.2.3.4" data-path="part6/634.html">
            
                
                    <a href="../part6/634.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.3.4.</b>
                        
                         请求锁
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.3.5" data-path="part6/635.html">
            
                
                    <a href="../part6/635.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.3.5.</b>
                        
                         销毁锁
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.2.4" data-path="part6/mutex_unixc.html">
            
                
                    <a href="../part6/mutex_unixc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.4.</b>
                        
                         mutex_unix.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.4.1" data-path="part6/641.html">
            
                
                    <a href="../part6/641.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.4.1.</b>
                        
                         互斥锁结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.4.2" data-path="part6/642.html">
            
                
                    <a href="../part6/642.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.4.2.</b>
                        
                         函数功能
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.2.5" data-path="part6/mutex_noopc.html">
            
                
                    <a href="../part6/mutex_noopc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.5.</b>
                        
                         mutex_noop.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.5.1" data-path="part6/451.html">
            
                
                    <a href="../part6/451.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.5.1.</b>
                        
                         非调试情况
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.5.2" data-path="part6/652.html">
            
                
                    <a href="../part6/652.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.5.2.</b>
                        
                         调试的情况
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.2.6" data-path="part6/memjournalc.html">
            
                
                    <a href="../part6/memjournalc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.6.</b>
                        
                         memjournal.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.6.1" data-path="part6/661.html">
            
                
                    <a href="../part6/661.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.6.1.</b>
                        
                         日志相关存储结构
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.2.6.1.1" data-path="part6/6611.html">
            
                
                    <a href="../part6/6611.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.6.1.1.</b>
                        
                         函数指针结构体
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.2.6.2" data-path="part6/662.html">
            
                
                    <a href="../part6/662.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.6.2.</b>
                        
                         函数功能表
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.6.3" data-path="part6/663.html">
            
                
                    <a href="../part6/663.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.6.3.</b>
                        
                         打开内存日志
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.6.4" data-path="part6/664.html">
            
                
                    <a href="../part6/664.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.6.4.</b>
                        
                         读取内存日志
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.2.6.5" data-path="part6/665.html">
            
                
                    <a href="../part6/665.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.2.6.5.</b>
                        
                         是否为内存日志文件
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.3" data-path="part5/1.html">
            
                
                    <a href="../part5/1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.3.</b>
                        
                         memjournal.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.3.1" data-path="part5/51.html">
            
                
                    <a href="../part5/51.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.3.1.</b>
                        
                         函数及结构体功能
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.4" data-path="wal/wal.html">
            
                
                    <a href="../wal/wal.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.4.</b>
                        
                         Wal的介绍
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5" data-path="wal/README.html">
            
                
                    <a href="../wal/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.</b>
                        
                         Wal的工作原理
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="6.5.1" data-path="wal/wal1.html">
            
                
                    <a href="../wal/wal1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.1.</b>
                        
                         Wal的优缺点
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5.2" data-path="wal/work.html">
            
                
                    <a href="../wal/work.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.2.</b>
                        
                         工作原理
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5.3" data-path="wal/filestyle.html">
            
                
                    <a href="../wal/filestyle.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.3.</b>
                        
                         Wal文件格式
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5.4" data-path="wal/checksumcheck.html">
            
                
                    <a href="../wal/checksumcheck.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.4.</b>
                        
                         校验
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5.5" data-path="wal/readread.html">
            
                
                    <a href="../wal/readread.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.5.</b>
                        
                         读写事务
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5.6" data-path="wal/savepointsvae.html">
            
                
                    <a href="../wal/savepointsvae.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.6.</b>
                        
                         保存点
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5.7" data-path="wal/ability.html">
            
                
                    <a href="../wal/ability.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.7.</b>
                        
                         性能问题
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="6.5.8" data-path="wal/checkpointcheckpoint.html">
            
                
                    <a href="../wal/checkpointcheckpoint.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.5.8.</b>
                        
                         检查点
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="6.6" data-path="references/lockandmutex.html">
            
                
                    <a href="../references/lockandmutex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>6.6.</b>
                        
                         lockandmutex
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7" data-path="introduce/READMEG12.html">
            
                
                    <a href="../introduce/READMEG12.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.</b>
                        
                         共享组件
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.1" data-path="introduce/crewG12.html">
            
                
                    <a href="../introduce/crewG12.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.1.</b>
                        
                         目录管理器
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2" data-path="introduce/workG12.html">
            
                
                    <a href="../introduce/workG12.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.</b>
                        
                         内存分配器
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.1" data-path="part2/README.html">
            
                
                    <a href="../part2/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.</b>
                        
                         动态内存分配器
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.1.1" data-path="part2/mem0c.html">
            
                
                    <a href="../part2/mem0c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.1.</b>
                        
                         空操作内存分配器（mem0.c）
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.1.2" data-path="part2/mem1c.html">
            
                
                    <a href="../part2/mem1c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.2.</b>
                        
                          缺省内存分配器（mem1.c）
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.1.3" data-path="part2/mem2c.html">
            
                
                    <a href="../part2/mem2c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.3.</b>
                        
                         调试内存分配器（mem2.c）
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.1.3.1" data-path="part2/backtrace.html">
            
                
                    <a href="../part2/backtrace.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.3.1.</b>
                        
                         关于backtrace
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.1.3.2" data-path="part2/2_3_2.html">
            
                
                    <a href="../part2/2_3_2.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.3.2.</b>
                        
                         设置哨兵对内存破坏进行检查
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.1.3.3" data-path="part2/unfree_list.html">
            
                
                    <a href="../part2/unfree_list.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.3.3.</b>
                        
                         通过unfree list检查内存泄露
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.2.1.4" data-path="part2/2_4.html">
            
                
                    <a href="../part2/2_4.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.1.4.</b>
                        
                         内存分配函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.2.2" data-path="mem/README.html">
            
                
                    <a href="../mem/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.2.</b>
                        
                         内存分配器
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.2.1" data-path="mem/article.html">
            
                
                    <a href="../mem/article.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.2.1.</b>
                        
                         mem0.c
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.2.2" data-path="mem/mem1c.html">
            
                
                    <a href="../mem/mem1c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.2.2.</b>
                        
                         mem1.c
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.2.3" data-path="mem/mem2c.html">
            
                
                    <a href="../mem/mem2c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.2.3.</b>
                        
                         mem2.c
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.2.4" data-path="mem/mem3c.html">
            
                
                    <a href="../mem/mem3c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.2.4.</b>
                        
                         mem3.c
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.2.5" data-path="mem/mem4c.html">
            
                
                    <a href="../mem/mem4c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.2.5.</b>
                        
                         mem5.c
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.2.3" data-path="part3/README.html">
            
                
                    <a href="../part3/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.3.</b>
                        
                         Mem3.c代码分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.3.1" data-path="part3/mem3c.html">
            
                
                    <a href="../part3/mem3c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.3.1.</b>
                        
                         Mem3.c功能概述
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.3.2" data-path="part3/3_1.html">
            
                
                    <a href="../part3/3_1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.3.2.</b>
                        
                         名词及相关概念
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.3.3" data-path="part3/3_3.html">
            
                
                    <a href="../part3/3_3.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.3.3.</b>
                        
                         块存储结构 
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.3.3.1" data-path="part3/3_3_1.html">
            
                
                    <a href="../part3/3_3_1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.3.3.1.</b>
                        
                         内存分配结构体 
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.2.3.4" data-path="part3/3_4.html">
            
                
                    <a href="../part3/3_4.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.3.4.</b>
                        
                         Mem3.c函数列表
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.3.5" data-path="part3/3_5.html">
            
                
                    <a href="../part3/3_5.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.3.5.</b>
                        
                         函数代码解析
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.2.4" data-path="part4/article.html">
            
                
                    <a href="../part4/article.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.4.</b>
                        
                         mem5.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.4.1" data-path="part4/41_mem5c.html">
            
                
                    <a href="../part4/41_mem5c.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.4.1.</b>
                        
                         mem5.c功能概述
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.4.2" data-path="part4/mem5cc.html">
            
                
                    <a href="../part4/mem5cc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.4.2.</b>
                        
                         mem5.c调用的C接口
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.4.3" data-path="part4/43.html">
            
                
                    <a href="../part4/43.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.4.3.</b>
                        
                         名词及相关概念
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.4.4" data-path="part4/44.html">
            
                
                    <a href="../part4/44.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.4.4.</b>
                        
                         函数及结构体功能
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.4.5" data-path="part4/45.html">
            
                
                    <a href="../part4/45.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.4.5.</b>
                        
                         重要代码解析
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.2.5" data-path="mallocc/README.html">
            
                
                    <a href="../mallocc/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.5.</b>
                        
                         Malloc.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.2.5.1" data-path="mallocc/future.html">
            
                
                    <a href="../mallocc/future.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.5.1.</b>
                        
                         特性
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.5.2" data-path="mallocc/test.html">
            
                
                    <a href="../mallocc/test.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.5.2.</b>
                        
                         测试
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.5.3" data-path="mallocc/config.html">
            
                
                    <a href="../mallocc/config.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.5.3.</b>
                        
                         配置
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.5.4" data-path="mallocc/api.html">
            
                
                    <a href="../mallocc/api.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.5.4.</b>
                        
                         API介绍
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.2.5.5" data-path="mallocc/summry.html">
            
                
                    <a href="../mallocc/summry.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.5.5.</b>
                        
                         总结
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.2.6" data-path="introduce/dynamicmemorymalloc.html">
            
                
                    <a href="../introduce/dynamicmemorymalloc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.2.6.</b>
                        
                         dynamicmemorymalloc
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.3" data-path="conclusion/README.html">
            
                
                    <a href="../conclusion/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.</b>
                        
                         其他工具
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.3.1" data-path="sqlite/sqlitelimiteh.html">
            
                
                    <a href="../sqlite/sqlitelimiteh.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.1.</b>
                        
                         SqliteLimite.h
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.2" data-path="sqlite/sqliteinth.html">
            
                
                    <a href="../sqlite/sqliteinth.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.2.</b>
                        
                         SqliteInt.h
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.3" data-path="sqlite/globalc.html">
            
                
                    <a href="../sqlite/globalc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.3.</b>
                        
                         Global.c模块源码分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.4" data-path="mainc/READMEG16.html">
            
                
                    <a href="../mainc/READMEG16.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.4.</b>
                        
                         主函数分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.3.4.1" data-path="vdbeInt&amp;vdbemem887/vdbememc887.html">
            
                
                    <a href="../vdbeInt&amp;vdbemem887/vdbememc887.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.4.1.</b>
                        
                         vdbemem.c分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.3.4.1.1" data-path="vdbemem/vdbememsqlitevdbe.html">
            
                
                    <a href="../vdbemem/vdbememsqlitevdbe.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.4.1.1.</b>
                        
                         SQLite的虚拟机
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.4.1.2" data-path="vdbemem/vdbememvdbememccode.html">
            
                
                    <a href="../vdbemem/vdbememvdbememccode.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.4.1.2.</b>
                        
                         结构体&quot;Mem&quot;的操作函数-vdbemem.c
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.3.4.2" data-path="mainc/hanshu.html">
            
                
                    <a href="../mainc/hanshu.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.4.2.</b>
                        
                         函数功能
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.4.3" data-path="mainc/caozuo.html">
            
                
                    <a href="../mainc/caozuo.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.4.3.</b>
                        
                         操作控制
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5" data-path="printf/printfsqlite.html">
            
                
                    <a href="../printf/printfsqlite.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.</b>
                        
                         Printf.c分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.3.5.1" data-path="printf/datatype.html">
            
                
                    <a href="../printf/datatype.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.1.</b>
                        
                         数据类型定义
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.2" data-path="printf/sqlite3AppendSpace.html">
            
                
                    <a href="../printf/sqlite3AppendSpace.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.2.</b>
                        
                         sqlite3AppendSpace()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.3" data-path="printf/sqlite3vxprintf.html">
            
                
                    <a href="../printf/sqlite3vxprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.3.</b>
                        
                         sqlite3VXPrintf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.4" data-path="printf/sqlite3straccumappend.html">
            
                
                    <a href="../printf/sqlite3straccumappend.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.4.</b>
                        
                         sqlite3StrAccumAppend()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.5" data-path="printf/sqlite3straccumfinish.html">
            
                
                    <a href="../printf/sqlite3straccumfinish.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.5.</b>
                        
                         *sqlite3StrAccumFinish()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.6" data-path="printf/sqlite3straccumreset.html">
            
                
                    <a href="../printf/sqlite3straccumreset.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.6.</b>
                        
                         sqlite3StrAccumReset()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.7" data-path="printf/sqlite3straccuminit.html">
            
                
                    <a href="../printf/sqlite3straccuminit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.7.</b>
                        
                         sqlite3StrAccumInit()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.8" data-path="printf/sqlite3vmprintf.html">
            
                
                    <a href="../printf/sqlite3vmprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.8.</b>
                        
                         *sqlite3VMPrintf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.9" data-path="printf/sqlite3mprintf.html">
            
                
                    <a href="../printf/sqlite3mprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.9.</b>
                        
                         *sqlite3MPrintf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.10" data-path="printf/sqlite3mappendf.html">
            
                
                    <a href="../printf/sqlite3mappendf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.10.</b>
                        
                         *sqlite3MAppendf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.11" data-path="printf/sqlite3_vmprintf.html">
            
                
                    <a href="../printf/sqlite3_vmprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.11.</b>
                        
                         *sqlite3_vmprintf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.12" data-path="printf/sqlite3_mprintf.html">
            
                
                    <a href="../printf/sqlite3_mprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.12.</b>
                        
                         *sqlite3_mprintf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.13" data-path="printf/sqlite3_vsnprintfsqlite3_snprintf.html">
            
                
                    <a href="../printf/sqlite3_vsnprintfsqlite3_snprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.13.</b>
                        
                         *sqlite3_vsnprintf()函数；*sqlite3_snprintf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.14" data-path="printf/renderlogmsg.html">
            
                
                    <a href="../printf/renderlogmsg.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.14.</b>
                        
                         renderLogMsg()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.15" data-path="printf/sqlite3_log.html">
            
                
                    <a href="../printf/sqlite3_log.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.15.</b>
                        
                         sqlite3_log()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.16" data-path="printf/sqlite3debugprintf.html">
            
                
                    <a href="../printf/sqlite3debugprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.16.</b>
                        
                         sqlite3DebugPrintf()函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.5.17" data-path="printf/sqlite3xprintf.html">
            
                
                    <a href="../printf/sqlite3xprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.5.17.</b>
                        
                         sqlite3XPrintf()函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6" data-path="date/datecG22.html">
            
                
                    <a href="../date/datecG22.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.</b>
                        
                         date.c模块源码分析
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.3.6.1" data-path="date/datestruct.html">
            
                
                    <a href="../date/datestruct.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.1.</b>
                        
                         主要结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6.2" data-path="date/getsystem.html">
            
                
                    <a href="../date/getsystem.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.2.</b>
                        
                         获取系统读数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6.3" data-path="date/gettimediff.html">
            
                
                    <a href="../date/gettimediff.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.3.</b>
                        
                         读取时区差异扩展表示格式
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6.4" data-path="date/changetime.html">
            
                
                    <a href="../date/changetime.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.4.</b>
                        
                         正常时间与儒略日数之间的相互转换
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6.5" data-path="date/julian_day_number.html">
            
                
                    <a href="../date/julian_day_number.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.5.</b>
                        
                         转换为Julian Day Number所发生的的错误个数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6.6" data-path="date/getcurrenttime.html">
            
                
                    <a href="../date/getcurrenttime.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.6.</b>
                        
                         获取系统当前时间
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6.7" data-path="date/grammaroptimize.html">
            
                
                    <a href="../date/grammaroptimize.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.7.</b>
                        
                         时间戳的语法改良
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.6.8" data-path="date/timeshow.html">
            
                
                    <a href="../date/timeshow.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.6.8.</b>
                        
                         时间的表示
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.3.7" data-path="sqlite/utilCode.html">
            
                
                    <a href="../sqlite/utilCode.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.7.</b>
                        
                         util.c分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.8" data-path="utf.c&amp;vacuum/utf.html">
            
                
                    <a href="../utf.c&amp;vacuum/utf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.8.</b>
                        
                         utf.c分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.9" data-path="date/ctimec.html">
            
                
                    <a href="../date/ctimec.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.9.</b>
                        
                         Ctime.c模块源码分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.10" data-path="printfc/printfc.html">
            
                
                    <a href="../printfc/printfc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.</b>
                        
                         Printf.c
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.3.10.1" data-path="printfc/updatecprgn.html">
            
                
                    <a href="../printfc/updatecprgn.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.1.</b>
                        
                         功能
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.10.2" data-path="printfc/hdy.html">
            
                
                    <a href="../printfc/hdy.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.2.</b>
                        
                         宏定义
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.10.3" data-path="printfc/jgt.html">
            
                
                    <a href="../printfc/jgt.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.3.</b>
                        
                         结构体
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.10.4" data-path="printfc/function.html">
            
                
                    <a href="../printfc/function.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.4.</b>
                        
                         函数
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="7.3.10.4.1" data-path="printfc/et_getdigit.html">
            
                
                    <a href="../printfc/et_getdigit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.4.1.</b>
                        
                         et_getdigit
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.10.4.2" data-path="printfc/sqlite3appendspace.html">
            
                
                    <a href="../printfc/sqlite3appendspace.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.4.2.</b>
                        
                         sqlite3AppendSpace
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.10.4.3" data-path="printfc/sqlite3vxprintf.html">
            
                
                    <a href="../printfc/sqlite3vxprintf.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.4.3.</b>
                        
                         sqlite3VXPrintf
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.10.4.4" data-path="printfc/qths.html">
            
                
                    <a href="../printfc/qths.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.10.4.4.</b>
                        
                         其他函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.3.11" data-path="date/datec1.html">
            
                
                    <a href="../date/datec1.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.11.</b>
                        
                         date.c模块源码分析(1)
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.12" data-path="date/datec.html">
            
                
                    <a href="../date/datec.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.12.</b>
                        
                         date.c模块源码分析(2)
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.3.13" data-path="conclusion/forexample">
            
                
                    <a href="../conclusion/forexample">
                        <i class="fa fa-check"></i>
                        
                            <b>7.3.13.</b>
                        
                         forexample
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="7.4" data-path="sqlite/completec.html">
            
                
                    <a href="../sqlite/completec.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.4.</b>
                        
                         complete.c模块源码分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.5" data-path="sqlite/callbackc.html">
            
                
                    <a href="../sqlite/callbackc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.5.</b>
                        
                         callback.c模块源码分析
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.6" data-path="sqlite/hash.html">
            
                
                    <a href="../sqlite/hash.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.6.</b>
                        
                         Hash
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="7.7" data-path="introduce/sqliteG12.html">
            
                
                    <a href="../introduce/sqliteG12.html">
                        <i class="fa fa-check"></i>
                        
                            <b>7.7.</b>
                        
                         Sqlite源代码介绍
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="8" data-path="clp/shellclp.html">
            
                
                    <a href="../clp/shellclp.html">
                        <i class="fa fa-check"></i>
                        
                            <b>8.</b>
                        
                         Shell模式下使用CLP
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="8.1" data-path="clp/dosclp.html">
            
                
                    <a href="../clp/dosclp.html">
                        <i class="fa fa-check"></i>
                        
                            <b>8.1.</b>
                        
                         命令行模式下的CLP
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="8.2" data-path="function/api.html">
            
                
                    <a href="../function/api.html">
                        <i class="fa fa-check"></i>
                        
                            <b>8.2.</b>
                        
                         重要的API函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="8.3" data-path="function/user.html">
            
                
                    <a href="../function/user.html">
                        <i class="fa fa-check"></i>
                        
                            <b>8.3.</b>
                        
                         用户自定义函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="8.4" data-path="result/code.html">
            
                
                    <a href="../result/code.html">
                        <i class="fa fa-check"></i>
                        
                            <b>8.4.</b>
                        
                         结果代码
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        
        <li class="chapter " data-level="9" data-path="sqlfuncc/README.html">
            
                
                    <a href="../sqlfuncc/README.html">
                        <i class="fa fa-check"></i>
                        
                            <b>9.</b>
                        
                         实现SQL的各种函数(func.c的源码分析)
                    </a>
                
            
            
            <ul class="articles">
                
    
        
        <li class="chapter " data-level="9.1" data-path="sqlfuncc/jisuan.html">
            
                
                    <a href="../sqlfuncc/jisuan.html">
                        <i class="fa fa-check"></i>
                        
                            <b>9.1.</b>
                        
                         算术函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="9.2" data-path="sqlfuncc/zifu.html">
            
                
                    <a href="../sqlfuncc/zifu.html">
                        <i class="fa fa-check"></i>
                        
                            <b>9.2.</b>
                        
                         字符处理函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="9.3" data-path="sqlfuncc/tiaojian.html">
            
                
                    <a href="../sqlfuncc/tiaojian.html">
                        <i class="fa fa-check"></i>
                        
                            <b>9.3.</b>
                        
                         条件判断函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="9.4" data-path="sqlfuncc/jihe.html">
            
                
                    <a href="../sqlfuncc/jihe.html">
                        <i class="fa fa-check"></i>
                        
                            <b>9.4.</b>
                        
                         集合函数
                    </a>
                
            
            
        </li>
    
        
        <li class="chapter " data-level="9.5" data-path="sqlfuncc/qita.html">
            
                
                    <a href="../sqlfuncc/qita.html">
                        <i class="fa fa-check"></i>
                        
                            <b>9.5.</b>
                        
                         其他函数
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    


        
        <li class="divider"></li>
        <li>
            <a href="http://www.gitbook.io/" target="blank" class="gitbook-link">Generated using GitBook</a>
        </li>
        
    </ul>
</div>

    <div class="book-body">
        <div class="body-inner">
            <div class="page-wrapper" tabindex="-1">
                <div class="book-progress">
    <div class="bar">
        <div class="inner" style="width: 63.241106719367586%;min-width: 63.04347826086956%;"></div>
    </div>
    <div class="chapters">
    
        <a href="../index.html" title="首页" class="chapter done new-chapter" data-progress="0" style="left: 0%;"></a>
    
        <a href="../sqlite/sqliteintro.html" title="SQLite简介" class="chapter done new-chapter" data-progress="1" style="left: 0.1976284584980237%;"></a>
    
        <a href="../vdbemem/vdbememsqliteintro.html" title="SQLite特性" class="chapter done " data-progress="1.1" style="left: 0.3952569169960474%;"></a>
    
        <a href="../sqlite/introduce.html" title="推荐使用场景" class="chapter done " data-progress="1.2" style="left: 0.5928853754940712%;"></a>
    
        <a href="../sqlite/READMEG14.html" title="快速使用SQLite" class="chapter done " data-progress="1.3" style="left: 0.7905138339920948%;"></a>
    
        <a href="../sqlite/architecture.html" title="SQLite体系结构" class="chapter done new-chapter" data-progress="2" style="left: 0.9881422924901185%;"></a>
    
        <a href="../sqlite/system.html" title="体系结构" class="chapter done " data-progress="2.1" style="left: 1.1857707509881423%;"></a>
    
        <a href="../sqlite/sqlitemodule.html" title="各结构作用" class="chapter done " data-progress="2.2" style="left: 1.383399209486166%;"></a>
    
        <a href="../vdbemem/summary.html" title="进程模型" class="chapter done new-chapter" data-progress="3" style="left: 1.5810276679841897%;"></a>
    
        <a href="../vdbeInt&amp;vdbemem887/whatIsVdbe.html" title="什么是VDBE" class="chapter done " data-progress="3.1" style="left: 1.7786561264822134%;"></a>
    
        <a href="../vdbeInt&amp;vdbemem887/sqlite&amp;vdbe.html" title="sqLite为什么要使用虚拟机" class="chapter done " data-progress="3.1.1" style="left: 1.976284584980237%;"></a>
    
        <a href="../vdbeInt&amp;vdbemem887/vdbeProcess.html" title="VDBE的运行" class="chapter done " data-progress="3.1.2" style="left: 2.1739130434782608%;"></a>
    
        <a href="../vdbeInt&amp;vdbemem887/vdbeInt.html" title="vdbeInt.h简介" class="chapter done " data-progress="3.1.3" style="left: 2.3715415019762847%;"></a>
    
        <a href="../vdbe/README.html" title="VDBE执行方法" class="chapter done " data-progress="3.2" style="left: 2.569169960474308%;"></a>
    
        <a href="../execuing_of_vdbec/README.html" title="SQLite执行与VDBE" class="chapter done " data-progress="3.3" style="left: 2.766798418972332%;"></a>
    
        <a href="../execuing_of_vdbec/op_init.html" title="OP_Init" class="chapter done " data-progress="3.3.1" style="left: 2.964426877470356%;"></a>
    
        <a href="../execuing_of_vdbec/op_transaction.html" title="OP_Transaction" class="chapter done " data-progress="3.3.2" style="left: 3.1620553359683794%;"></a>
    
        <a href="../execuing_of_vdbec/op_tablelock.html" title="OP_TableLock" class="chapter done " data-progress="3.3.3" style="left: 3.3596837944664033%;"></a>
    
        <a href="../execuing_of_vdbec/op_goto.html" title="OP_Goto" class="chapter done " data-progress="3.3.4" style="left: 3.5573122529644268%;"></a>
    
        <a href="../execuing_of_vdbec/op_readcookie.html" title="OP_ReadCookie" class="chapter done " data-progress="3.3.5" style="left: 3.7549407114624507%;"></a>
    
        <a href="../execuing_of_vdbec/op_if.html" title="OP_If" class="chapter done " data-progress="3.3.6" style="left: 3.952569169960474%;"></a>
    
        <a href="../execuing_of_vdbec/op_integer1.html" title="OP_Integer1" class="chapter done " data-progress="3.3.7" style="left: 4.150197628458498%;"></a>
    
        <a href="../execuing_of_vdbec/op_setcookie.html" title="OP_SetCookie" class="chapter done " data-progress="3.3.10" style="left: 4.3478260869565215%;"></a>
    
        <a href="../execuing_of_vdbec/op_integer2.html" title="OP_Integer2" class="chapter done " data-progress="3.3.9" style="left: 4.545454545454546%;"></a>
    
        <a href="../execuing_of_vdbec/op_createtable.html" title="OP_CreateTable" class="chapter done " data-progress="3.3.11" style="left: 4.743083003952569%;"></a>
    
        <a href="../execuing_of_vdbec/op_openwrite.html" title="OP_OpenWrite" class="chapter done " data-progress="3.3.12" style="left: 4.940711462450593%;"></a>
    
        <a href="../execuing_of_vdbec/op_newrowid.html" title="OP_NewRowid" class="chapter done " data-progress="3.3.13" style="left: 5.138339920948616%;"></a>
    
        <a href="../execuing_of_vdbec/op_null1.html" title="OP_Null1" class="chapter done " data-progress="3.3.14" style="left: 5.335968379446641%;"></a>
    
        <a href="../execuing_of_vdbec/op_insert.html" title="OP_Insert" class="chapter done " data-progress="3.3.15" style="left: 5.533596837944664%;"></a>
    
        <a href="../execuing_of_vdbec/op_close1.html" title="OP_Close1" class="chapter done " data-progress="3.3.16" style="left: 5.7312252964426875%;"></a>
    
        <a href="../execuing_of_vdbec/op_close2.html" title="OP_Close2" class="chapter done " data-progress="3.3.17" style="left: 5.928853754940712%;"></a>
    
        <a href="../execuing_of_vdbec/op_null2.html" title="OP_Null2" class="chapter done " data-progress="3.3.18" style="left: 6.126482213438735%;"></a>
    
        <a href="../execuing_of_vdbec/op_openwrite1.html" title="OP_OpenWrite1" class="chapter done " data-progress="3.3.19" style="left: 6.324110671936759%;"></a>
    
        <a href="../execuing_of_vdbec/op_mustbeint.html" title="OP_MustBeInt" class="chapter done " data-progress="3.3.20" style="left: 6.521739130434782%;"></a>
    
        <a href="../execuing_of_vdbec/op_notexists.html" title="OP_NotExists" class="chapter done " data-progress="3.3.21" style="left: 6.719367588932807%;"></a>
    
        <a href="../execuing_of_vdbec/op_rowid.html" title="OP_Rowid" class="chapter done " data-progress="3.3.22" style="left: 6.91699604743083%;"></a>
    
        <a href="../execuing_of_vdbec/op_isnull.html" title="OP_IsNull" class="chapter done " data-progress="3.3.23" style="left: 7.1146245059288535%;"></a>
    
        <a href="../execuing_of_vdbec/op_string.html" title="OP_String" class="chapter done " data-progress="3.3.24" style="left: 7.312252964426878%;"></a>
    
        <a href="../execuing_of_vdbec/op_string1.html" title="OP_String1" class="chapter done " data-progress="3.3.25" style="left: 7.509881422924901%;"></a>
    
        <a href="../execuing_of_vdbec/op_string2.html" title="OP_String2" class="chapter done " data-progress="3.3.26" style="left: 7.707509881422925%;"></a>
    
        <a href="../execuing_of_vdbec/op_copy.html" title="OP_Copy" class="chapter done " data-progress="3.3.27" style="left: 7.905138339920948%;"></a>
    
        <a href="../execuing_of_vdbec/op_string3.html" title="OP_String3" class="chapter done " data-progress="3.3.28" style="left: 8.102766798418973%;"></a>
    
        <a href="../execuing_of_vdbec/op_makerecord.html" title="OP_MakeRecord" class="chapter done " data-progress="3.3.29" style="left: 8.300395256916996%;"></a>
    
        <a href="../execuing_of_vdbec/op_insert1.html" title="OP_Insert1" class="chapter done " data-progress="3.3.30" style="left: 8.49802371541502%;"></a>
    
        <a href="../execuing_of_vdbec/op_close3.html" title="OP_Close3" class="chapter done " data-progress="3.3.31" style="left: 8.695652173913043%;"></a>
    
        <a href="../execuing_of_vdbec/op_integer3.html" title="OP_Integer3" class="chapter done " data-progress="3.3.32" style="left: 8.893280632411066%;"></a>
    
        <a href="../execuing_of_vdbec/op_setcookie1.html" title="OP_SetCookie1" class="chapter done " data-progress="3.3.33" style="left: 9.090909090909092%;"></a>
    
        <a href="../execuing_of_vdbec/op_parseschema.html" title="OP_ParseSchema" class="chapter done " data-progress="3.3.34" style="left: 9.288537549407115%;"></a>
    
        <a href="../execuing_of_vdbec/op_halt.html" title="OP_Halt" class="chapter done " data-progress="3.3.35" style="left: 9.486166007905139%;"></a>
    
        <a href="../execuing_procedure_of_vdbe/README.html" title="SQLite执行过程" class="chapter done " data-progress="3.4" style="left: 9.683794466403162%;"></a>
    
        <a href="../vdbeauxc/preview.html" title="vdbeaux.c源码概览" class="chapter done " data-progress="3.5" style="left: 9.881422924901186%;"></a>
    
        <a href="../vdbeauxc/intrduceandanaly.html" title="vdbeaux.c 源码介绍与分析" class="chapter done " data-progress="3.6" style="left: 10.079051383399209%;"></a>
    
        <a href="../vdbeauxc/createfame.html" title="创建vdbe结构体" class="chapter done " data-progress="3.6.1" style="left: 10.276679841897232%;"></a>
    
        <a href="../vdbeauxc/prepare.html" title="vdbe准备阶段" class="chapter done " data-progress="3.6.2" style="left: 10.474308300395258%;"></a>
    
        <a href="../vdbeauxc/update.html" title="相关修改函数" class="chapter done " data-progress="3.6.2.1" style="left: 10.671936758893281%;"></a>
    
        <a href="../vdbeauxc/assemble.html" title="配置函数" class="chapter done " data-progress="3.6.2.2" style="left: 10.869565217391305%;"></a>
    
        <a href="../vdbeauxc/xigou.html" title="析构函数" class="chapter done " data-progress="3.6.2.3" style="left: 11.067193675889328%;"></a>
    
        <a href="../vdbeauxc/debug.html" title="debug模式" class="chapter done " data-progress="3.6.3" style="left: 11.264822134387352%;"></a>
    
        <a href="../vdbeauxc/deleframe.html" title="删除vdbe结构体" class="chapter done " data-progress="3.6.3.1" style="left: 11.462450592885375%;"></a>
    
        <a href="../vdbeauxc/list.html" title="列出虚拟机中的程序清单" class="chapter done " data-progress="3.6.3.2" style="left: 11.660079051383399%;"></a>
    
        <a href="../vdbeauxc/display.html" title="显示部分" class="chapter done " data-progress="3.6.3.3" style="left: 11.857707509881424%;"></a>
    
        <a href="../vdbeauxc/alloc.html" title="分配空间" class="chapter done " data-progress="3.6.4" style="left: 12.055335968379447%;"></a>
    
        <a href="../vdbeauxc/init.html" title="初始化vdbe" class="chapter done " data-progress="3.6.5" style="left: 12.25296442687747%;"></a>
    
        <a href="../vdbeauxc/makeready.html" title="执行前的准备" class="chapter done " data-progress="3.6.6" style="left: 12.450592885375494%;"></a>
    
        <a href="../vdbeauxc/free.html" title="释放资源" class="chapter done " data-progress="3.6.7" style="left: 12.648221343873518%;"></a>
    
        <a href="../vdbeauxc/process.html" title="vdbe执行中的处理" class="chapter done " data-progress="3.6.8" style="left: 12.845849802371541%;"></a>
    
        <a href="../vdbeauxc/halt.html" title="函数sqlite3VdbeHalt" class="chapter done " data-progress="3.6.8.1" style="left: 13.043478260869565%;"></a>
    
        <a href="../vdbeauxc/stepresult.html" title="函数sqlite3VdbeResetStepResult" class="chapter done " data-progress="3.6.8.2" style="left: 13.24110671936759%;"></a>
    
        <a href="../vdbeauxc/transfererror.html" title="函数sqlite3VdbeTransferError" class="chapter done " data-progress="3.6.8.3" style="left: 13.438735177865613%;"></a>
    
        <a href="../vdbeauxc/reset.html" title="函数sqlite3VdbeReset" class="chapter done " data-progress="3.6.8.4" style="left: 13.636363636363637%;"></a>
    
        <a href="../vdbeauxc/finalize.html" title="函数sqlite3VdbeFinalize" class="chapter done " data-progress="3.6.8.5" style="left: 13.83399209486166%;"></a>
    
        <a href="../vdbeauxc/deleobjectanddelete.html" title="函数sqlite3VdbeDeleteObject和sqlite3VdbeDelete" class="chapter done " data-progress="3.6.8.6" style="left: 14.031620553359684%;"></a>
    
        <a href="../vdbeauxc/moveto.html" title="函数sqlite3VdbeCursorMoveto" class="chapter done " data-progress="3.6.8.7" style="left: 14.229249011857707%;"></a>
    
        <a href="../vdbeauxc/flowswap.html" title="函数u64 floatSwap" class="chapter done " data-progress="3.6.8.8" style="left: 14.42687747035573%;"></a>
    
        <a href="../vdbeauxc/serialput.html" title="函数sqlite3VdbeSerialPut" class="chapter done " data-progress="3.6.8.9" style="left: 14.624505928853756%;"></a>
    
        <a href="../vdbeauxc/unpackedrecord.html" title="函数sqlite3VdbeAllocUnpackedRecord" class="chapter done " data-progress="3.6.8.10" style="left: 14.82213438735178%;"></a>
    
        <a href="../vdbeauxc/statements.html" title="函数sqlite3ExpirePreparedStatements" class="chapter done " data-progress="3.6.8.11" style="left: 15.019762845849803%;"></a>
    
        <a href="../vdbeauxc/setvarmask.html" title="函数sqlite3VdbeSetVarmask" class="chapter done " data-progress="3.6.8.12" style="left: 15.217391304347826%;"></a>
    
        <a href="../vdbesort/preview2.html" title="vdbesort.c源码概览" class="chapter done " data-progress="3.7" style="left: 15.41501976284585%;"></a>
    
        <a href="../vdbesort/nintrodution.html" title="N-路归并的算法及数据结构说明" class="chapter done " data-progress="3.7.1" style="left: 15.612648221343873%;"></a>
    
        <a href="../vdbesort/structs.html" title="结构体定义" class="chapter done " data-progress="3.7.2" style="left: 15.810276679841897%;"></a>
    
        <a href="../vdbesort/functions.html" title="函数定义" class="chapter done " data-progress="3.7.3" style="left: 16.007905138339922%;"></a>
    
        <a href="../srcAnaly/README.html" title="关系查询处理器" class="chapter done new-chapter" data-progress="4" style="left: 16.205533596837945%;"></a>
    
        <a href="../srcAnaly/selectExec.html" title="查询解析和授权" class="chapter done " data-progress="4.1" style="left: 16.40316205533597%;"></a>
    
        <a href="../sqlite/sqlasunderstoodbysqlite.html" title="SQLite中的SQL语句" class="chapter done " data-progress="4.1.1" style="left: 16.600790513833992%;"></a>
    
        <a href="../dir2/selectgrammar.html" title="SELECT的语法图" class="chapter done " data-progress="4.1.2" style="left: 16.798418972332016%;"></a>
    
        <a href="../dir2/selectexe.html" title="SQLite中SQL语句执行步骤" class="chapter done " data-progress="4.1.3" style="left: 16.99604743083004%;"></a>
    
        <a href="../srcAnaly/keyFunc.html" title="sqlite查询处理的关键函数" class="chapter done " data-progress="4.1.4" style="left: 17.193675889328063%;"></a>
    
        <a href="../dir2/selecttree.html" title="查询语法树" class="chapter done " data-progress="4.1.5" style="left: 17.391304347826086%;"></a>
    
        <a href="../srcanaly/from.html" title="FROM子句" class="chapter done " data-progress="4.1.6" style="left: 17.58893280632411%;"></a>
    
        <a href="../srcanaly/sqlitefrom.html" title="SQLite中FROM子句的使用" class="chapter done " data-progress="4.1.6.1" style="left: 17.786561264822133%;"></a>
    
        <a href="../dir3/sqliteselectcolumnsfromexprlist.html" title="SQLite中FROM子句的实现" class="chapter done " data-progress="4.1.6.2" style="left: 17.984189723320156%;"></a>
    
        <a href="../dir3/articledir.html" title="ON子句" class="chapter done " data-progress="4.1.7" style="left: 18.181818181818183%;"></a>
    
        <a href="../dir3/on.html" title="SQLite中ON子句的使用" class="chapter done " data-progress="4.1.7.1" style="left: 18.379446640316207%;"></a>
    
        <a href="../dir3/sqlitesqlite3jointypesetjoinexprsqliteprocessjoin.html" title="SQLite中ON子句的实现" class="chapter done " data-progress="4.1.7.2" style="left: 18.57707509881423%;"></a>
    
        <a href="../authc/README.html" title="访问授权" class="chapter done " data-progress="4.1.8" style="left: 18.774703557312254%;"></a>
    
        <a href="../srcanaly/authorization.html" title="SQLite的授权检查实现" class="chapter done " data-progress="4.1.8.1" style="left: 18.972332015810277%;"></a>
    
        <a href="../authc/set.html" title="设置或清除访问授权" class="chapter done " data-progress="4.1.8.2" style="left: 19.1699604743083%;"></a>
    
        <a href="../authc/authbadreturncode.html" title="授权返回一个非法的值" class="chapter done " data-progress="4.1.8.3" style="left: 19.367588932806324%;"></a>
    
        <a href="../authc/authreadcol.html" title="验证数据库中表的列信息是否可访问" class="chapter done " data-progress="4.1.8.4" style="left: 19.565217391304348%;"></a>
    
        <a href="../authc/tk_column.html" title="验证解析树中TK_COLUMN表达式是否可访问" class="chapter done " data-progress="4.1.8.5" style="left: 19.76284584980237%;"></a>
    
        <a href="../authc/authcheck.html" title="使用给定的代码和参数的授权检查" class="chapter done " data-progress="4.1.8.6" style="left: 19.960474308300395%;"></a>
    
        <a href="../authc/authcontext.html" title="利用栈存储解析树的授权内容" class="chapter done " data-progress="4.1.8.7" style="left: 20.158102766798418%;"></a>
    
        <a href="../dir3/selectsourcedir.html" title="查询重写" class="chapter done " data-progress="4.2" style="left: 20.35573122529644%;"></a>
    
        <a href="../dir3/rewritefunction.html" title="重写器的主要功能" class="chapter done " data-progress="4.2.1" style="left: 20.553359683794465%;"></a>
    
        <a href="../optimalandquery/optimalquery.html" title="SQLite查询重写" class="chapter done " data-progress="4.2.2" style="left: 20.75098814229249%;"></a>
    
        <a href="../optimalandquery/transcation.html" title="几类查询重写" class="chapter done " data-progress="4.2.2.1" style="left: 20.948616600790515%;"></a>
    
        <a href="../optimalandquery/compress.html" title="子查询扁平化" class="chapter done " data-progress="4.2.2.2" style="left: 21.14624505928854%;"></a>
    
        <a href="../optimalandquery/link.html" title="连接查询" class="chapter done " data-progress="4.2.2.3" style="left: 21.343873517786562%;"></a>
    
        <a href="../dir3/wheredir.html" title="WHERE子句" class="chapter done " data-progress="4.2.3" style="left: 21.541501976284586%;"></a>
    
        <a href="../dir3/where.html" title="WHERE子句具体使用" class="chapter done " data-progress="4.2.3.1" style="left: 21.73913043478261%;"></a>
    
        <a href="../dir3/sqliteaddwheretermselectinnerloop.html" title="SQLite中使用addWhereTerm函数和selectInnerLoop函数" class="chapter done " data-progress="4.2.3.2" style="left: 21.936758893280633%;"></a>
    
        <a href="../dir3/group_bydir.html" title="GROUP BY子句" class="chapter done " data-progress="4.2.4" style="left: 22.134387351778656%;"></a>
    
        <a href="../dir3/group.html" title="GROUP子句具体使用" class="chapter done " data-progress="4.2.4.1" style="left: 22.33201581027668%;"></a>
    
        <a href="../dir3/sqlitefinalizeaggfunctions.html" title="SQLite中finalizeAggFunctions函数" class="chapter done " data-progress="4.2.4.2" style="left: 22.529644268774703%;"></a>
    
        <a href="../dir3/havingdir.html" title="Having子句" class="chapter done " data-progress="4.2.5" style="left: 22.727272727272727%;"></a>
    
        <a href="../dir3/distinctdir.html" title="DISTINCT子句" class="chapter done " data-progress="4.2.6" style="left: 22.92490118577075%;"></a>
    
        <a href="../dir3/361____alldistinct.html" title="all和distinct子句" class="chapter done " data-progress="4.2.6.1" style="left: 23.122529644268774%;"></a>
    
        <a href="../dir3/codedistinct.html" title="codeDistinct函数" class="chapter done " data-progress="4.2.6.2" style="left: 23.320158102766797%;"></a>
    
        <a href="../dir3/order_bydir.html" title="ORDER BY子句" class="chapter done " data-progress="4.2.7" style="left: 23.51778656126482%;"></a>
    
        <a href="../dir3/order_by.html" title="ORDER BY子句具体应用" class="chapter done " data-progress="4.2.7.1" style="left: 23.715415019762847%;"></a>
    
        <a href="../dir3/sqlitemultiselectorderby.html" title="SQLite中multiSelectOrderBy函数" class="chapter done " data-progress="4.2.7.2" style="left: 23.91304347826087%;"></a>
    
        <a href="../dir3/limitdir.html" title="LIMIT子句" class="chapter done " data-progress="4.2.8" style="left: 24.110671936758894%;"></a>
    
        <a href="../dir3/sqlitecomputelimitregisters.html" title="SQLite中computeLimitRegisters函数" class="chapter done " data-progress="4.2.8.1" style="left: 24.308300395256918%;"></a>
    
        <a href="../dir3/offsetdir.html" title="OFFSET子句" class="chapter done " data-progress="4.2.9" style="left: 24.50592885375494%;"></a>
    
        <a href="../dir3/other.html" title="另外一些重要的函数" class="chapter done " data-progress="4.2.10" style="left: 24.703557312252965%;"></a>
    
        <a href="../dir3/sqlite3selectprep.html" title="sqlite3SelectPrep函数" class="chapter done " data-progress="4.2.10.1" style="left: 24.90118577075099%;"></a>
    
        <a href="../dir3/sqlite3getvdbe.html" title="sqlite3GetVdbe函数" class="chapter done " data-progress="4.2.10.2" style="left: 25.09881422924901%;"></a>
    
        <a href="../dir3/minmaxquery.html" title="minMaxQuery函数" class="chapter done " data-progress="4.2.10.3" style="left: 25.296442687747035%;"></a>
    
        <a href="../queryoptiintro/queryoptiintro.html" title="查询优化器" class="chapter done " data-progress="4.3" style="left: 25.49407114624506%;"></a>
    
        <a href="../queryoptiintro/queryoptiflow.html" title="查询优化流程" class="chapter done " data-progress="4.3.1" style="left: 25.691699604743082%;"></a>
    
        <a href="../queryoptiintro/queryoptiop.html" title="SQLite中几种查询优化做的处理" class="chapter done " data-progress="4.3.2" style="left: 25.889328063241106%;"></a>
    
        <a href="../queryoptiintro/queryoptistrategy.html" title="查询扫描策略" class="chapter done " data-progress="4.3.3" style="left: 26.08695652173913%;"></a>
    
        <a href="../queryoptiintro/costmodule.html" title="查询策略代价模型及计算方式" class="chapter done " data-progress="4.3.4" style="left: 26.284584980237153%;"></a>
    
        <a href="../analyzeanalyzec/README.html" title="与查询代价有关的处理-ANALYZE命令" class="chapter done " data-progress="4.3.5" style="left: 26.48221343873518%;"></a>
    
        <a href="../analyzeanalyzec/analyzesql.html" title="Analyze的SQL语法" class="chapter done " data-progress="4.3.5.1" style="left: 26.679841897233203%;"></a>
    
        <a href="../analyzeanalyzec/analyze.html" title="Analyze 命令接口" class="chapter done " data-progress="4.3.5.2" style="left: 26.877470355731226%;"></a>
    
        <a href="../analyzeanalyzec/analyzedatabase.html" title="analyzeDatabase函数" class="chapter done " data-progress="4.3.5.3" style="left: 27.07509881422925%;"></a>
    
        <a href="../analyzeanalyzec/analyzetable.html" title="analyzeTable函数" class="chapter done " data-progress="4.3.5.4" style="left: 27.272727272727273%;"></a>
    
        <a href="../analyzeanalyzec/loadanalysis.html" title="loadAnalysis函数" class="chapter done " data-progress="4.3.5.5" style="left: 27.470355731225297%;"></a>
    
        <a href="../analyzeanalyzec/analyzeonetable.html" title="analyzeOneTable函数" class="chapter done " data-progress="4.3.5.6" style="left: 27.66798418972332%;"></a>
    
        <a href="../analyzeanalyzec/stat3initstat3pushstat3get.html" title="stat3Init函数，stat3Push函数，stat3Get函数" class="chapter done " data-progress="4.3.5.7" style="left: 27.865612648221344%;"></a>
    
        <a href="../analyzeanalyzec/other.html" title="其他用到的一些函数" class="chapter done " data-progress="4.3.5.8" style="left: 28.063241106719367%;"></a>
    
        <a href="../wherec/README.html" title="SQLite中查询优化的具体实现" class="chapter done " data-progress="4.3.6" style="left: 28.26086956521739%;"></a>
    
        <a href="../wherec/sqlite3wherebegin.html" title="sqlite3WhereBegin函数" class="chapter done " data-progress="4.3.6.1" style="left: 28.458498023715414%;"></a>
    
        <a href="../wherec/expranalyzeall.html" title="exprAnalyzeAll函数" class="chapter done " data-progress="4.3.6.2" style="left: 28.656126482213438%;"></a>
    
        <a href="../wherec/expranalyze.html" title="exprAnalyze函数" class="chapter done " data-progress="4.3.6.3" style="left: 28.85375494071146%;"></a>
    
        <a href="../wherec/bestbtreeindex.html" title="bestBtreeIndex函数" class="chapter done " data-progress="4.3.6.4" style="left: 29.051383399209485%;"></a>
    
        <a href="../wherec/bestorclauseindex.html" title="bestOrClauseIndex函数" class="chapter done " data-progress="4.3.6.5" style="left: 29.24901185770751%;"></a>
    
        <a href="../wherec/whererangescanest.html" title="whereRangeScanEst函数" class="chapter done " data-progress="4.3.6.6" style="left: 29.446640316205535%;"></a>
    
        <a href="../wherec/codeoneloopstart.html" title="codeOneLoopStart函数" class="chapter done " data-progress="4.3.6.7" style="left: 29.64426877470356%;"></a>
    
        <a href="../wherec/sqlite3whereend.html" title="sqlite3WhereEnd函数" class="chapter done " data-progress="4.3.6.8" style="left: 29.841897233201582%;"></a>
    
        <a href="../wherec/wherec.html" title="where.c概述" class="chapter done " data-progress="4.3.7" style="left: 30.039525691699605%;"></a>
    
        <a href="../wherec/wherecInfo/wherecprocess.html" title="where.c的执行过程" class="chapter done " data-progress="4.3.7.1" style="left: 30.23715415019763%;"></a>
    
        <a href="../wherec/wherecInfo/structandfunc.html" title="where.c中主要结构体和函数调用关系" class="chapter done " data-progress="4.3.7.2" style="left: 30.434782608695652%;"></a>
    
        <a href="../wherec/wherecInfo/struct.html" title="主要结构体" class="chapter done " data-progress="4.3.7.2.1" style="left: 30.632411067193676%;"></a>
    
        <a href="../wherec/wherecInfo/func.html" title="主要函数调用关系" class="chapter done " data-progress="4.3.7.2.2" style="left: 30.8300395256917%;"></a>
    
        <a href="../wherec/where.html" title="where子句的查询优化" class="chapter done " data-progress="4.3.7.3" style="left: 31.027667984189723%;"></a>
    
        <a href="../wherec/whereOptimize/whereanalyze.html" title="WHERE子句分析" class="chapter done " data-progress="4.3.7.3.1" style="left: 31.225296442687746%;"></a>
    
        <a href="../wherec/whereOptimize/between.html" title="BETWEEN语句优化" class="chapter done " data-progress="4.3.7.3.2" style="left: 31.42292490118577%;"></a>
    
        <a href="../wherec/whereOptimize/or.html" title="OR语句优化" class="chapter done " data-progress="4.3.7.3.3" style="left: 31.620553359683793%;"></a>
    
        <a href="../wherec/whereOptimize/like.html" title="LIKE语句优化" class="chapter done " data-progress="4.3.7.3.4" style="left: 31.818181818181817%;"></a>
    
        <a href="../wherec/whereOptimize/skip-scan.html" title="Skip-Scan优化" class="chapter done " data-progress="4.3.7.3.5" style="left: 32.015810276679844%;"></a>
    
        <a href="../wherec/whereOptimize/selmultindex.html" title="多重索引的选择" class="chapter done " data-progress="4.3.7.3.6" style="left: 32.21343873517787%;"></a>
    
        <a href="../wherec/whereOptimize/coverindex.html" title="覆盖索引" class="chapter done " data-progress="4.3.7.3.7" style="left: 32.41106719367589%;"></a>
    
        <a href="../wherec/whereOptimize/autoindex.html" title="自动索引" class="chapter done " data-progress="4.3.7.3.8" style="left: 32.608695652173914%;"></a>
    
        <a href="../wherec/wherecsummary.html" title="wherecSummary" class="chapter done " data-progress="4.3.7.4" style="left: 32.80632411067194%;"></a>
    
        <a href="../queryoptiintro/queryoptisummary.html" title="SQLite中查询优化方式的总结" class="chapter done " data-progress="4.3.8" style="left: 33.00395256916996%;"></a>
    
        <a href="../dir2/introduction.html" title="查询执行器" class="chapter done " data-progress="4.4" style="left: 33.201581027667984%;"></a>
    
        <a href="../dir2/dataalter.html" title="数据修改语句" class="chapter done " data-progress="4.4.1" style="left: 33.39920948616601%;"></a>
    
        <a href="../buildc/buildcsqlite.html" title="Build.c分析" class="chapter done " data-progress="4.4.2" style="left: 33.59683794466403%;"></a>
    
        <a href="../buildc/function.html" title="实现的功能" class="chapter done " data-progress="4.4.2.1" style="left: 33.794466403162055%;"></a>
    
        <a href="../function/achieve.html" title="具体功能的实现" class="chapter done " data-progress="4.4.2.2" style="left: 33.99209486166008%;"></a>
    
        <a href="../function/createtable.html" title="表的创建" class="chapter done " data-progress="4.4.2.2.1" style="left: 34.1897233201581%;"></a>
    
        <a href="../function/del.html" title="表的删除" class="chapter done " data-progress="4.4.2.2.2" style="left: 34.387351778656125%;"></a>
    
        <a href="../function/othertable.html" title="与表相关的操作" class="chapter done " data-progress="4.4.2.2.3" style="left: 34.58498023715415%;"></a>
    
        <a href="../function/createView.html" title="视图的创建" class="chapter done " data-progress="4.4.2.2.4" style="left: 34.78260869565217%;"></a>
    
        <a href="../index/create.html" title="索引的创建" class="chapter done " data-progress="4.4.2.2.5" style="left: 34.980237154150196%;"></a>
    
        <a href="../index/select.html" title="索引的删除" class="chapter done " data-progress="4.4.2.2.6" style="left: 35.17786561264822%;"></a>
    
        <a href="../index/free.html" title="释放索引（与删除索引相关）" class="chapter done " data-progress="4.4.2.2.7" style="left: 35.37549407114624%;"></a>
    
        <a href="../index/other.html" title="与索引相关的其他操作" class="chapter done " data-progress="4.4.2.2.8" style="left: 35.573122529644266%;"></a>
    
        <a href="../id/idcreate.html" title="ID序列的创建" class="chapter done " data-progress="4.4.2.2.9" style="left: 35.77075098814229%;"></a>
    
        <a href="../id/idselect.html" title="ID序列的删除" class="chapter done " data-progress="4.4.2.2.10" style="left: 35.96837944664031%;"></a>
    
        <a href="../id/idother.html" title="ID序列其他操作" class="chapter done " data-progress="4.4.2.2.11" style="left: 36.16600790513834%;"></a>
    
        <a href="../routine/routinestart.html" title="事务的开始" class="chapter done " data-progress="4.4.2.2.12" style="left: 36.36363636363637%;"></a>
    
        <a href="../routine/routinesubmit.html" title="事务的提交" class="chapter done " data-progress="4.4.2.2.13" style="left: 36.56126482213439%;"></a>
    
        <a href="../routine/routinerollback.html" title="事务的回滚" class="chapter done " data-progress="4.4.2.2.14" style="left: 36.758893280632414%;"></a>
    
        <a href="../function/temporarydb.html" title="临时数据库" class="chapter done " data-progress="4.4.2.2.15" style="left: 36.95652173913044%;"></a>
    
        <a href="../function/write.html" title="写操作" class="chapter done " data-progress="4.4.2.2.16" style="left: 37.15415019762846%;"></a>
    
        <a href="../function/exception.html" title="异常检查" class="chapter done " data-progress="4.4.2.2.17" style="left: 37.351778656126484%;"></a>
    
        <a href="../insertc/README.html" title="Insert.c解析" class="chapter done " data-progress="4.4.3" style="left: 37.54940711462451%;"></a>
    
        <a href="../insertc/insert.html" title="insert的主要关系" class="chapter done " data-progress="4.4.3.1" style="left: 37.74703557312253%;"></a>
    
        <a href="../insertc/sqlite3opentable.html" title="sqlite3OpenTable()" class="chapter done " data-progress="4.4.3.2" style="left: 37.944664031620555%;"></a>
    
        <a href="../insertc/sqlite3indexaffinitystr.html" title="sqlite3IndexAffinityStr()" class="chapter done " data-progress="4.4.3.3" style="left: 38.14229249011858%;"></a>
    
        <a href="../insertc/sqlite3tableaffinitystr.html" title="sqlite3TableAffinityStr()" class="chapter done " data-progress="4.4.3.4" style="left: 38.3399209486166%;"></a>
    
        <a href="../insertc/static_int_readstable.html" title="static int readsTable()" class="chapter done " data-progress="4.4.3.5" style="left: 38.537549407114625%;"></a>
    
        <a href="../insertc/static_int_autoincbegin.html" title="static int autoIncBegin()" class="chapter done " data-progress="4.4.3.6" style="left: 38.73517786561265%;"></a>
    
        <a href="../insertc/void_sqlite3autoincrementbegin.html" title="void sqlite3AutoincrementBegin()" class="chapter done " data-progress="4.4.3.7" style="left: 38.93280632411067%;"></a>
    
        <a href="../insertc/static_void_autoincstep.html" title="static void autoIncStep()" class="chapter done " data-progress="4.4.3.8" style="left: 39.130434782608695%;"></a>
    
        <a href="../insertc/sqlite3autoincrementend.html" title="sqlite3AutoincrementEnd()" class="chapter done " data-progress="4.4.3.9" style="left: 39.32806324110672%;"></a>
    
        <a href="../insertc/xferoptimization.html" title="xferOptimization()" class="chapter done " data-progress="4.4.3.10" style="left: 39.52569169960474%;"></a>
    
        <a href="../insertc/sqlite3insert.html" title="sqlite3Insert()" class="chapter done " data-progress="4.4.3.11" style="left: 39.723320158102766%;"></a>
    
        <a href="../insertc/sqlite3generateconstraintchecks.html" title="sqlite3GenerateConstraintChecks()" class="chapter done " data-progress="4.4.3.12" style="left: 39.92094861660079%;"></a>
    
        <a href="../insertc/sqlite3completeinsertion.html" title="sqlite3CompleteInsertion()" class="chapter done " data-progress="4.4.3.13" style="left: 40.11857707509881%;"></a>
    
        <a href="../insertc/sqlite3opentableandindices.html" title="sqlite3OpenTableAndIndices()" class="chapter done " data-progress="4.4.3.14" style="left: 40.316205533596836%;"></a>
    
        <a href="../insertc/xfercompatiblecollation.html" title="xferCompatibleCollation()" class="chapter done " data-progress="4.4.3.15" style="left: 40.51383399209486%;"></a>
    
        <a href="../insertc/xfercompatibleindex.html" title="xferCompatibleIndex()" class="chapter done " data-progress="4.4.3.16" style="left: 40.71146245059288%;"></a>
    
        <a href="../deletecupdatec/READMEG22.html" title="分析delete.c和update.c" class="chapter done " data-progress="4.4.4" style="left: 40.90909090909091%;"></a>
    
        <a href="../deletecupdatec/cast.html" title="CAST函数" class="chapter done " data-progress="4.4.4.1" style="left: 41.10671936758893%;"></a>
    
        <a href="../deletecupdatec/escape.html" title="ESCAPE" class="chapter done " data-progress="4.4.4.2" style="left: 41.30434782608695%;"></a>
    
        <a href="../deletecupdatec/likeglob.html" title="Like和Glob" class="chapter done " data-progress="4.4.4.3" style="left: 41.50197628458498%;"></a>
    
        <a href="../deletecupdatec/isnull.html" title="ISNULL" class="chapter done " data-progress="4.4.4.4" style="left: 41.69960474308301%;"></a>
    
        <a href="../deletecupdatec/between.html" title="between" class="chapter done " data-progress="4.4.4.5" style="left: 41.89723320158103%;"></a>
    
        <a href="../deletecupdatec/exist.html" title="EXISTS" class="chapter done " data-progress="4.4.4.6" style="left: 42.094861660079054%;"></a>
    
        <a href="../deletecupdatec/case_when.html" title="case when" class="chapter done " data-progress="4.4.4.7" style="left: 42.29249011857708%;"></a>
    
        <a href="../deletecupdatec/raise.html" title="RAISE()函数" class="chapter done " data-progress="4.4.4.8" style="left: 42.4901185770751%;"></a>
    
        <a href="../deletecupdatec/delete.html" title="Delete.c中主要函数的实现及功能" class="chapter done " data-progress="4.4.5" style="left: 42.687747035573125%;"></a>
    
        <a href="../deletecupdatec/sqlite3srclistlookup.html" title="sqlite3SrcListLookup()函数" class="chapter done " data-progress="4.4.5.1" style="left: 42.88537549407115%;"></a>
    
        <a href="../deletecupdatec/sqlite3isreadonly.html" title="sqlite3IsReadOnly()函数" class="chapter done " data-progress="4.4.5.2" style="left: 43.08300395256917%;"></a>
    
        <a href="../deletecupdatec/sqlite3materializeview.html" title="sqlite3MaterializeView()函数" class="chapter done " data-progress="4.4.5.3" style="left: 43.280632411067195%;"></a>
    
        <a href="../deletecupdatec/sqlite3limitwhere.html" title="sqlite3LimitWhere()函数" class="chapter done " data-progress="4.4.5.4" style="left: 43.47826086956522%;"></a>
    
        <a href="../deletecupdatec/sqlite3deletefrom.html" title="sqlite3DeleteFrom()函数" class="chapter done " data-progress="4.4.5.5" style="left: 43.67588932806324%;"></a>
    
        <a href="../deletecupdatec/sqlite3generaterowdelete.html" title="sqlite3GenerateRowDelete()函数" class="chapter done " data-progress="4.4.5.6" style="left: 43.873517786561266%;"></a>
    
        <a href="../deletecupdatec/sqlite3generaterowindexdelete.html" title="sqlite3GenerateRowIndexDelete()函数" class="chapter done " data-progress="4.4.5.7" style="left: 44.07114624505929%;"></a>
    
        <a href="../deletecupdatec/sqlite3generateindexkey.html" title="sqlite3GenerateIndexKey()函数" class="chapter done " data-progress="4.4.5.8" style="left: 44.26877470355731%;"></a>
    
        <a href="../updatec/updatec.html" title="Update.c简介" class="chapter done " data-progress="4.4.6" style="left: 44.466403162055336%;"></a>
    
        <a href="../updatec/sqlite3columndefault.html" title="sqlite3ColumnDefault函数说明" class="chapter done " data-progress="4.4.6.1" style="left: 44.66403162055336%;"></a>
    
        <a href="../updatec/sqlite3columndefault1.html" title="sqlite3ColumnDefault函数结构" class="chapter done " data-progress="4.4.6.2" style="left: 44.86166007905138%;"></a>
    
        <a href="../updatec/sqlite3columndefault2.html" title="函数流程图" class="chapter done " data-progress="4.4.6.3" style="left: 45.059288537549406%;"></a>
    
        <a href="../updatec/updatecsuhssm.html" title="sqlite3Update函数说明" class="chapter done " data-progress="4.4.6.4" style="left: 45.25691699604743%;"></a>
    
        <a href="../updatec/updatecsuhsjg.html" title="sqlite3Update函数结构" class="chapter done " data-progress="4.4.6.5" style="left: 45.45454545454545%;"></a>
    
        <a href="../updatec/updatecsuhslct.html" title="sqlite3Update函数流程图" class="chapter done " data-progress="4.4.6.6" style="left: 45.65217391304348%;"></a>
    
        <a href="../updatec/updatecuphssm.html" title="updateVirtualtable函数说明" class="chapter done " data-progress="4.4.6.7" style="left: 45.8498023715415%;"></a>
    
        <a href="../updatec/updatevirtualtable.html" title="updateVirtualtable函数结构" class="chapter done " data-progress="4.4.6.8" style="left: 46.047430830039524%;"></a>
    
        <a href="../updatec/updatecuvhslct.html" title="updateVirtualtable函数流程图" class="chapter done " data-progress="4.4.6.9" style="left: 46.24505928853755%;"></a>
    
        <a href="../deletecupdatec/update.html" title="Update.c中主要函数的实现及功能" class="chapter done " data-progress="4.4.7" style="left: 46.44268774703557%;"></a>
    
        <a href="../deletecupdatec/sqlite3columndefault.html" title="sqlite3ColumnDefault()函数" class="chapter done " data-progress="4.4.7.1" style="left: 46.640316205533594%;"></a>
    
        <a href="../deletecupdatec/sqlite3update.html" title="sqlite3Update()函数" class="chapter done " data-progress="4.4.7.2" style="left: 46.83794466403162%;"></a>
    
        <a href="../deletecupdatec/updatevirtualtable.html" title="updateVirtualTable()函数" class="chapter done " data-progress="4.4.7.3" style="left: 47.03557312252964%;"></a>
    
        <a href="../triggerc/triggerjj.html" title="Trigger.c" class="chapter done " data-progress="4.4.8" style="left: 47.23320158102767%;"></a>
    
        <a href="../triggerc/jbyf.html" title="基本语法" class="chapter done " data-progress="4.4.8.1" style="left: 47.430830039525695%;"></a>
    
        <a href="../triggerc/hsjs.html" title="函数介绍" class="chapter done " data-progress="4.4.8.2" style="left: 47.62845849802372%;"></a>
    
        <a href="../triggerc/cfqmm.html" title="触发器编码（Code）" class="chapter done " data-progress="4.4.8.3" style="left: 47.82608695652174%;"></a>
    
        <a href="../triggerc/triggerssssdfsd.html" title="sqlite3BeginTrigger和sqlite3FinishTrigger" class="chapter done " data-progress="4.4.8.4" style="left: 48.023715415019765%;"></a>
    
        <a href="../triggerc/triggerstep.html" title="Step" class="chapter done " data-progress="4.4.8.5" style="left: 48.22134387351779%;"></a>
    
        <a href="../alter_tablealterc/README.html" title="实现修改表功能ALTER TABLE（alter.c的源码分析）" class="chapter done " data-progress="4.4.9" style="left: 48.41897233201581%;"></a>
    
        <a href="../alter_tablealterc/renametablefunc.html" title="重命名表的名称" class="chapter done " data-progress="4.4.9.1" style="left: 48.616600790513836%;"></a>
    
        <a href="../alter_tablealterc/renameparentfunc.html" title="修改任何外键约束定义重命名表为父表" class="chapter done " data-progress="4.4.9.2" style="left: 48.81422924901186%;"></a>
    
        <a href="../alter_tablealterc/renametriggerfunc.html" title="对触发器的表名做修改" class="chapter done " data-progress="4.4.9.3" style="left: 49.01185770750988%;"></a>
    
        <a href="../alter_tablealterc/whereorname.html" title="创建表达式形式的文本" class="chapter done " data-progress="4.4.9.4" style="left: 49.209486166007906%;"></a>
    
        <a href="../alter_tablealterc/whereforeignkeys.html" title="生成用来选择有外键约束的全部表的表达式文本" class="chapter done " data-progress="4.4.9.5" style="left: 49.40711462450593%;"></a>
    
        <a href="../alter_tablealterc/ptab.html" title="删除和重新加载从数据库表pTab的内部模式" class="chapter done " data-progress="4.4.9.6" style="left: 49.60474308300395%;"></a>
    
        <a href="../alter_tablealterc/issystemtable.html" title="判断一个系统表" class="chapter done " data-progress="4.4.9.7" style="left: 49.80237154150198%;"></a>
    
        <a href="../alter_tablealterc/alterrenametable.html" title="删除表名并重命名为新表名" class="chapter done " data-progress="4.4.9.8" style="left: 50%;"></a>
    
        <a href="../dir2/selectinit.html" title="生成，清空，删除SELECT查询树函数" class="chapter done " data-progress="4.5" style="left: 50.19762845849802%;"></a>
    
        <a href="../queryoptiintro/sqlite.html" title="数据库扩展性" class="chapter done " data-progress="4.6" style="left: 50.39525691699605%;"></a>
    
        <a href="../queryoptiintro/virtualtable.html" title="virtualtable虚表" class="chapter done " data-progress="4.6.1" style="left: 50.59288537549407%;"></a>
    
        <a href="../utf.c&amp;vacuum/vacuum.html" title="vacuum.c分析" class="chapter done " data-progress="4.6.2" style="left: 50.790513833992094%;"></a>
    
        <a href="../loadextclegacyc/README.html" title="Loadext及clegacy.c文件解析" class="chapter done " data-progress="4.6.3" style="left: 50.98814229249012%;"></a>
    
        <a href="../rtree/gs.html" title="R-tree概述" class="chapter done " data-progress="4.6.4" style="left: 51.18577075098814%;"></a>
    
        <a href="../rtree/usertree.html" title="使用Rtree模块" class="chapter done " data-progress="4.6.5" style="left: 51.383399209486164%;"></a>
    
        <a href="../rtree/creatertree.html" title="创建一个Rtree索引" class="chapter done " data-progress="4.6.5.1" style="left: 51.58102766798419%;"></a>
    
        <a href="../rtree/getrtree.html" title="获取一个Rtree索引" class="chapter done " data-progress="4.6.5.2" style="left: 51.77865612648221%;"></a>
    
        <a href="../rtree/queryrtree.html" title="查询一个Rtree索引" class="chapter done " data-progress="4.6.5.3" style="left: 51.976284584980235%;"></a>
    
        <a href="../rtree/efficientuse.html" title="有效使用Rtree" class="chapter done " data-progress="4.6.6" style="left: 52.17391304347826%;"></a>
    
        <a href="../rtree/tailorrtree.html" title="定制R树查询" class="chapter done " data-progress="4.6.7" style="left: 52.37154150197628%;"></a>
    
        <a href="../rtree/xgeom.html" title="旧版本xGeom回调函数" class="chapter done " data-progress="4.6.7.1" style="left: 52.569169960474305%;"></a>
    
        <a href="../rtree/xqueryfunc.html" title="全新xQueryFunc回调函数" class="chapter done " data-progress="4.6.7.2" style="left: 52.76679841897233%;"></a>
    
        <a href="../rtree/tailorCare.html" title="定制查询注意事项" class="chapter done " data-progress="4.6.7.3" style="left: 52.96442687747036%;"></a>
    
        <a href="../rtree/READMEStruct.html" title="SQLiteR树结构" class="chapter done " data-progress="4.6.8" style="left: 53.16205533596838%;"></a>
    
        <a href="../rtree/NodeStruct.html" title="结点结构" class="chapter done " data-progress="4.6.8.1" style="left: 53.359683794466406%;"></a>
    
        <a href="../rtree/CellStruct.html" title="结点单元结构" class="chapter done " data-progress="4.6.8.2" style="left: 53.55731225296443%;"></a>
    
        <a href="../rtree/READMEImpention.html" title="R树特点及算法实现" class="chapter done " data-progress="4.6.9" style="left: 53.75494071146245%;"></a>
    
        <a href="../rtree/Searing.html" title="查找" class="chapter done " data-progress="4.6.9.1" style="left: 53.952569169960476%;"></a>
    
        <a href="../rtree/Insertion.html" title="插入" class="chapter done " data-progress="4.6.9.2" style="left: 54.1501976284585%;"></a>
    
        <a href="../rtree/Deletion.html" title="删除" class="chapter done " data-progress="4.6.9.3" style="left: 54.34782608695652%;"></a>
    
        <a href="../rtree/Update.html" title="更新" class="chapter done " data-progress="4.6.9.4" style="left: 54.54545454545455%;"></a>
    
        <a href="../rtree/QSplit.html" title="平方分裂" class="chapter done " data-progress="4.6.9.5" style="left: 54.74308300395257%;"></a>
    
        <a href="../rtree/LinearSplit.html" title="线性分裂" class="chapter done " data-progress="4.6.9.6" style="left: 54.940711462450594%;"></a>
    
        <a href="../rtree/READMEOptimize.html" title="R*树优化" class="chapter done " data-progress="4.6.10" style="left: 55.13833992094862%;"></a>
    
        <a href="../rtree/local.html" title="局部优化" class="chapter done " data-progress="4.6.10.1" style="left: 55.33596837944664%;"></a>
    
        <a href="../rtree/all.html" title="整体优化" class="chapter done " data-progress="4.6.10.2" style="left: 55.533596837944664%;"></a>
    
        <a href="../fts1/cjcode.html" title="全文索引" class="chapter done " data-progress="4.6.11" style="left: 55.73122529644269%;"></a>
    
        <a href="../fts1/fts.html" title="全文检索(full-text search)" class="chapter done " data-progress="4.6.12" style="left: 55.92885375494071%;"></a>
    
        <a href="../fts1/indexO.html" title="索引的组织结构" class="chapter done " data-progress="4.6.12.1" style="left: 56.126482213438734%;"></a>
    
        <a href="../fts1/indexC.html" title="索引的创建" class="chapter done " data-progress="4.6.12.2" style="left: 56.32411067193676%;"></a>
    
        <a href="../fts1/search.html" title="索引的搜索" class="chapter done " data-progress="4.6.12.3" style="left: 56.52173913043478%;"></a>
    
        <a href="../lemon/README.html" title="Lemon语法分析器模板文件" class="chapter done " data-progress="4.6.13" style="left: 56.719367588932805%;"></a>
    
        <a href="../sqlite/sqliteG2.html" title="分词器" class="chapter done " data-progress="4.6.14" style="left: 56.91699604743083%;"></a>
    
        <a href="../sqlite/tokenizer.html" title="Tokenizer运行原理" class="chapter done " data-progress="4.6.14.1" style="left: 57.11462450592885%;"></a>
    
        <a href="../sqlite/code.html" title="代码code发生器 " class="chapter done " data-progress="4.6.14.2" style="left: 57.312252964426875%;"></a>
    
        <a href="../sqlite/fts3.html" title="FTS3概述" class="chapter done " data-progress="4.6.14.3" style="left: 57.5098814229249%;"></a>
    
        <a href="../sqlite/fts_tokenizer.html" title="分词器：FTS tokenizer分析" class="chapter done " data-progress="4.6.14.4" style="left: 57.70750988142292%;"></a>
    
        <a href="../sqlite/16____tokenizers.html" title="自定义(用户)实现tokenizers" class="chapter done " data-progress="4.6.14.5" style="left: 57.905138339920946%;"></a>
    
        <a href="../fts3_exprc/fts3.html" title="FTS3" class="chapter done " data-progress="4.6.15" style="left: 58.10276679841897%;"></a>
    
        <a href="../fts3_exprc/fts3_exprcdoc.html" title="fts3_expr简介" class="chapter done " data-progress="4.6.15.1" style="left: 58.30039525691699%;"></a>
    
        <a href="../fts3_exprc/parsecontext.html" title="ParseContext结构体" class="chapter done " data-progress="4.6.15.2" style="left: 58.49802371541502%;"></a>
    
        <a href="../fts3_exprc/getnexttoken.html" title="getNextToken()函数" class="chapter done " data-progress="4.6.15.3" style="left: 58.69565217391305%;"></a>
    
        <a href="../fts3_exprc/getnextstring.html" title="getNextString()函数" class="chapter done " data-progress="4.6.15.4" style="left: 58.89328063241107%;"></a>
    
        <a href="../fts3_exprc/getnextnode.html" title="getNextNode()函数" class="chapter done " data-progress="4.6.15.5" style="left: 59.09090909090909%;"></a>
    
        <a href="../fts3_exprc/insertbinaryoperator.html" title="insertBinaryOperator()函数" class="chapter done " data-progress="4.6.15.6" style="left: 59.28853754940712%;"></a>
    
        <a href="../fts3_exprc/fts3exprparse.html" title="fts3ExprParse()函数" class="chapter done " data-progress="4.6.15.7" style="left: 59.48616600790514%;"></a>
    
        <a href="../fts3_exprc/sqlite3fts3exprparse.html" title="sqlite3Fts3ExprParse()函数" class="chapter done " data-progress="4.6.15.8" style="left: 59.683794466403164%;"></a>
    
        <a href="../optimalandquery/query.html" title="在SQLite3下查询数据" class="chapter done " data-progress="4.7" style="left: 59.88142292490119%;"></a>
    
        <a href="../srcAnaly/otherFunc.html" title="其它一些函数的功能" class="chapter done " data-progress="4.8" style="left: 60.07905138339921%;"></a>
    
        <a href="../summary/READMEG1.html" title="存储管理" class="chapter done new-chapter" data-progress="5" style="left: 60.276679841897234%;"></a>
    
        <a href="../summary/spacecontrol.html" title="文件系统" class="chapter done " data-progress="5.1" style="left: 60.47430830039526%;"></a>
    
        <a href="../functionandstructbody/analysis.html" title="文件函数及结构体分析" class="chapter done " data-progress="5.1.1" style="left: 60.67193675889328%;"></a>
    
        <a href="../third/fenxi.html" title="系统接口" class="chapter done " data-progress="5.1.2" style="left: 60.869565217391305%;"></a>
    
        <a href="../third/xjklc.html" title="简析打开数据库流程" class="chapter done " data-progress="5.1.2.1" style="left: 61.06719367588933%;"></a>
    
        <a href="../third/hsjg.html" title="简析os_win.c文件的函数结构" class="chapter done " data-progress="5.1.2.2" style="left: 61.26482213438735%;"></a>
    
        <a href="../third/sjz.html" title="简析SQLite的锁机制" class="chapter done " data-progress="5.1.2.3" style="left: 61.462450592885375%;"></a>
    
        <a href="../third/sxlc.html" title="SQLite在Windows系统上的锁机制实现流程" class="chapter done " data-progress="5.1.2.4" style="left: 61.6600790513834%;"></a>
    
        <a href="../third/sxym.html" title="锁机制在Windows中的实现源码" class="chapter done " data-progress="5.1.2.5" style="left: 61.85770750988142%;"></a>
    
        <a href="../filestruct/introduction.html" title="文件结构" class="chapter done " data-progress="5.1.2.6" style="left: 62.055335968379445%;"></a>
    
        <a href="../functionmainimplement/introduction.html" title="功能的主要实现" class="chapter done " data-progress="5.1.2.7" style="left: 62.25296442687747%;"></a>
    
        <a href="../summary/filesysteminterface" title="filesysteminterface" class="chapter done " data-progress="5.1.3" style="left: 62.45059288537549%;"></a>
    
        <a href="../B-treeImplementation/introduction.html" title="SQLite中B-tree的实现" class="chapter done " data-progress="5.2" style="left: 62.648221343873516%;"></a>
    
        <a href="../B-treeImplementation/sqliteb-tree.html" title="SQLite中的B-tree " class="chapter done " data-progress="5.2.1" style="left: 62.84584980237154%;"></a>
    
        <a href="../B-treeImplementation/hierarchicalorganization.html" title="SQLite层次化数据组织" class="chapter done " data-progress="5.2.2" style="left: 63.04347826086956%;"></a>
    
        <a href="../B-treeImplementation/overflow.html" title="页面溢出" class="chapter done " data-progress="5.2.3" style="left: 63.241106719367586%;"></a>
    
        <a href="../B-treeImplementation/b-tree_api.html" title="B-tree API" class="chapter  " data-progress="5.2.4" style="left: 63.43873517786561%;"></a>
    
        <a href="../B-treeImplementation/implement.html" title="实现的技术细节" class="chapter  " data-progress="5.2.5" style="left: 63.63636363636363%;"></a>
    
        <a href="../ljPager/pager.html" title="Pager概述" class="chapter  " data-progress="5.3" style="left: 63.83399209486166%;"></a>
    
        <a href="../ljPager/21.html" title="Pager状态" class="chapter  " data-progress="5.3.1" style="left: 64.03162055335969%;"></a>
    
        <a href="../ljPager/22.html" title="Pager的数据库文件页" class="chapter  " data-progress="5.3.2" style="left: 64.2292490118577%;"></a>
    
        <a href="../ljPager/23.html" title="Pager的相关参数" class="chapter  " data-progress="5.3.3" style="left: 64.42687747035573%;"></a>
    
        <a href="../ljPager/24.html" title="页面类型" class="chapter  " data-progress="5.3.4" style="left: 64.62450592885375%;"></a>
    
        <a href="../ljPager/25.html" title="Pager的状态" class="chapter  " data-progress="5.3.5" style="left: 64.82213438735178%;"></a>
    
        <a href="../ljPager/26.html" title="Pager的结构" class="chapter  " data-progress="5.3.6" style="left: 65.0197628458498%;"></a>
    
        <a href="../ljPager/27.html" title="日志" class="chapter  " data-progress="5.3.7" style="left: 65.21739130434783%;"></a>
    
        <a href="../ljPager/28.html" title="页面缓存" class="chapter  " data-progress="5.3.8" style="left: 65.41501976284584%;"></a>
    
        <a href="../ljPager/29.html" title="锁机制" class="chapter  " data-progress="5.3.9" style="left: 65.61264822134387%;"></a>
    
        <a href="../ljPager/sqlitepager.html" title="Pager的运行流程概述" class="chapter  " data-progress="5.4" style="left: 65.81027667984189%;"></a>
    
        <a href="../ljPager/31.html" title="打开/关闭一个页面连接" class="chapter  " data-progress="5.4.1" style="left: 66.00790513833992%;"></a>
    
        <a href="../ljPager/32.html" title="配置页面对象的函数" class="chapter  " data-progress="5.4.2" style="left: 66.20553359683794%;"></a>
    
        <a href="../ljPager/33.html" title="获取和释放页面引用的函数" class="chapter  " data-progress="5.4.3" style="left: 66.40316205533597%;"></a>
    
        <a href="../ljPager/34.html" title="对页面引用的操作" class="chapter  " data-progress="5.4.4" style="left: 66.60079051383399%;"></a>
    
        <a href="../ljPager/35.html" title="管理页面事务和保存点的函数" class="chapter  " data-progress="5.4.5" style="left: 66.79841897233202%;"></a>
    
        <a href="../ljPager/36.html" title="查询页面状态/配置" class="chapter  " data-progress="5.4.6" style="left: 66.99604743083005%;"></a>
    
        <a href="../ljPager/37.html" title="截断数据库文件" class="chapter  " data-progress="5.4.7" style="left: 67.19367588932806%;"></a>
    
        <a href="../ljPager/38.html" title="测试/调试" class="chapter  " data-progress="5.4.8" style="left: 67.3913043478261%;"></a>
    
        <a href="../cache analysis/pager/pagecache.html" title="页面缓冲管理" class="chapter  " data-progress="5.5" style="left: 67.58893280632411%;"></a>
    
        <a href="../cache analysis/pager/cachemanage.html" title="缓存管理" class="chapter  " data-progress="5.5.1" style="left: 67.78656126482214%;"></a>
    
        <a href="../cache analysis/pager/cacheorg.html" title="缓存组织" class="chapter  " data-progress="5.5.2" style="left: 67.98418972332016%;"></a>
    
        <a href="../cache analysis/pager/cache.html" title="cache具体结构" class="chapter  " data-progress="5.6" style="left: 68.18181818181819%;"></a>
    
        <a href="../cache analysis/pager/struct_pcachestruct_pcach1/pcahcevspcache1.html" title="Struct PCache与Struct PCach1" class="chapter  " data-progress="5.6.1" style="left: 68.3794466403162%;"></a>
    
        <a href="../cache analysis/pager/struct_pcache_vs_struct_pcache1/pghdrvspghdr1.html" title="Struct PCache VS Struct PCache1" class="chapter  " data-progress="5.6.2" style="left: 68.57707509881423%;"></a>
    
        <a href="../cache analysis/pager/struct_pghdr_1struct_pcache1/pghdr1andpcache1.html" title="struct PgHdr 1与struct PCache1" class="chapter  " data-progress="5.6.3" style="left: 68.77470355731225%;"></a>
    
        <a href="../cache analysis/pager/cache/cachestucture.html" title="cache内存结构" class="chapter  " data-progress="5.6.4" style="left: 68.97233201581028%;"></a>
    
        <a href="../cache analysis/pager/struct_pgroupstruct_pcacheglobal/pgroupandpcacheglobal.html" title="Struct PGroup与Struct PCacheGlobal" class="chapter  " data-progress="5.6.5" style="left: 69.1699604743083%;"></a>
    
        <a href="../bit/bitvecintro.html" title="Bitvec.c介绍" class="chapter  " data-progress="5.7" style="left: 69.36758893280633%;"></a>
    
        <a href="../bit/achieve.html" title="具体实现及源码分析" class="chapter  " data-progress="5.7.1" style="left: 69.56521739130434%;"></a>
    
        <a href="../References/introduction.html" title="事务:并发控制和恢复" class="chapter  new-chapter" data-progress="6" style="left: 69.76284584980237%;"></a>
    
        <a href="../lockandimplement/introduction.html" title="SQLite不同模式的锁与实现" class="chapter  " data-progress="6.1" style="left: 69.96047430830039%;"></a>
    
        <a href="../lockandimplement/machining.html" title="SQLite锁机制简介" class="chapter  " data-progress="6.1.1" style="left: 70.15810276679842%;"></a>
    
        <a href="../lockandimplement/method.html" title="文件加锁方法" class="chapter  " data-progress="6.1.2" style="left: 70.35573122529644%;"></a>
    
        <a href="../lockandimplement/posix.html" title="POSIX locking" class="chapter  " data-progress="6.1.2.1" style="left: 70.55335968379447%;"></a>
    
        <a href="../lockandimplement/noop.html" title="No-op Locking" class="chapter  " data-progress="6.1.2.2" style="left: 70.75098814229248%;"></a>
    
        <a href="../lockandimplement/dotfile.html" title="dot-file Locking" class="chapter  " data-progress="6.1.2.3" style="left: 70.94861660079052%;"></a>
    
        <a href="../lockandimplement/flock.html" title="flock Locking" class="chapter  " data-progress="6.1.2.4" style="left: 71.14624505928853%;"></a>
    
        <a href="../lockandimplement/semaphore.html" title="Named Semaphore Locking" class="chapter  " data-progress="6.1.2.5" style="left: 71.34387351778656%;"></a>
    
        <a href="../lockandimplement/afp.html" title="AFP Locking" class="chapter  " data-progress="6.1.2.6" style="left: 71.54150197628458%;"></a>
    
        <a href="../lockandimplement/function.html" title="各个锁机制实现函数" class="chapter  " data-progress="6.1.3" style="left: 71.73913043478261%;"></a>
    
        <a href="../part6/1.html" title="SQlite互斥锁分析" class="chapter  " data-progress="6.2" style="left: 71.93675889328063%;"></a>
    
        <a href="../part6/mutexh.html" title="mutex.h" class="chapter  " data-progress="6.2.1" style="left: 72.13438735177866%;"></a>
    
        <a href="../part6/mutexc.html" title="mutex.c" class="chapter  " data-progress="6.2.2" style="left: 72.33201581027669%;"></a>
    
        <a href="../part6/mutex.html" title="Mutex初始化" class="chapter  " data-progress="6.2.2.1" style="left: 72.5296442687747%;"></a>
    
        <a href="../part6/enter.html" title="互斥体enter使用" class="chapter  " data-progress="6.2.2.2" style="left: 72.72727272727273%;"></a>
    
        <a href="../part6/try.html" title="互斥体try使用" class="chapter  " data-progress="6.2.2.3" style="left: 72.92490118577075%;"></a>
    
        <a href="../part6/mutex_w32c.html" title="Mutex_w32.c" class="chapter  " data-progress="6.2.3" style="left: 73.12252964426878%;"></a>
    
        <a href="../part6/631.html" title="互斥锁结构体" class="chapter  " data-progress="6.2.3.1" style="left: 73.3201581027668%;"></a>
    
        <a href="../part6/632.html" title="设置结构体下的锁的函数指针" class="chapter  " data-progress="6.2.3.2" style="left: 73.51778656126483%;"></a>
    
        <a href="../part6/633.html" title="初始化互斥锁" class="chapter  " data-progress="6.2.3.3" style="left: 73.71541501976284%;"></a>
    
        <a href="../part6/6331.html" title="互斥锁结构体分配" class="chapter  " data-progress="6.2.3.3.1" style="left: 73.91304347826087%;"></a>
    
        <a href="../part6/634.html" title="请求锁" class="chapter  " data-progress="6.2.3.4" style="left: 74.11067193675889%;"></a>
    
        <a href="../part6/635.html" title="销毁锁" class="chapter  " data-progress="6.2.3.5" style="left: 74.30830039525692%;"></a>
    
        <a href="../part6/mutex_unixc.html" title="mutex_unix.c" class="chapter  " data-progress="6.2.4" style="left: 74.50592885375494%;"></a>
    
        <a href="../part6/641.html" title="互斥锁结构体" class="chapter  " data-progress="6.2.4.1" style="left: 74.70355731225297%;"></a>
    
        <a href="../part6/642.html" title="函数功能" class="chapter  " data-progress="6.2.4.2" style="left: 74.90118577075098%;"></a>
    
        <a href="../part6/mutex_noopc.html" title="mutex_noop.c" class="chapter  " data-progress="6.2.5" style="left: 75.09881422924902%;"></a>
    
        <a href="../part6/451.html" title="非调试情况" class="chapter  " data-progress="6.2.5.1" style="left: 75.29644268774703%;"></a>
    
        <a href="../part6/652.html" title="调试的情况" class="chapter  " data-progress="6.2.5.2" style="left: 75.49407114624506%;"></a>
    
        <a href="../part6/memjournalc.html" title="memjournal.c" class="chapter  " data-progress="6.2.6" style="left: 75.69169960474308%;"></a>
    
        <a href="../part6/661.html" title="日志相关存储结构" class="chapter  " data-progress="6.2.6.1" style="left: 75.88932806324111%;"></a>
    
        <a href="../part6/6611.html" title="函数指针结构体" class="chapter  " data-progress="6.2.6.1.1" style="left: 76.08695652173913%;"></a>
    
        <a href="../part6/662.html" title="函数功能表" class="chapter  " data-progress="6.2.6.2" style="left: 76.28458498023716%;"></a>
    
        <a href="../part6/663.html" title="打开内存日志" class="chapter  " data-progress="6.2.6.3" style="left: 76.48221343873517%;"></a>
    
        <a href="../part6/664.html" title="读取内存日志" class="chapter  " data-progress="6.2.6.4" style="left: 76.6798418972332%;"></a>
    
        <a href="../part6/665.html" title="是否为内存日志文件" class="chapter  " data-progress="6.2.6.5" style="left: 76.87747035573122%;"></a>
    
        <a href="../part5/1.html" title="memjournal.c" class="chapter  " data-progress="6.3" style="left: 77.07509881422925%;"></a>
    
        <a href="../part5/51.html" title="函数及结构体功能" class="chapter  " data-progress="6.3.1" style="left: 77.27272727272727%;"></a>
    
        <a href="../wal/wal.html" title="Wal的介绍" class="chapter  " data-progress="6.4" style="left: 77.4703557312253%;"></a>
    
        <a href="../wal/README.html" title="Wal的工作原理" class="chapter  " data-progress="6.5" style="left: 77.66798418972331%;"></a>
    
        <a href="../wal/wal1.html" title="Wal的优缺点" class="chapter  " data-progress="6.5.1" style="left: 77.86561264822134%;"></a>
    
        <a href="../wal/work.html" title="工作原理" class="chapter  " data-progress="6.5.2" style="left: 78.06324110671937%;"></a>
    
        <a href="../wal/filestyle.html" title="Wal文件格式" class="chapter  " data-progress="6.5.3" style="left: 78.26086956521739%;"></a>
    
        <a href="../wal/checksumcheck.html" title="校验" class="chapter  " data-progress="6.5.4" style="left: 78.45849802371542%;"></a>
    
        <a href="../wal/readread.html" title="读写事务" class="chapter  " data-progress="6.5.5" style="left: 78.65612648221344%;"></a>
    
        <a href="../wal/savepointsvae.html" title="保存点" class="chapter  " data-progress="6.5.6" style="left: 78.85375494071147%;"></a>
    
        <a href="../wal/ability.html" title="性能问题" class="chapter  " data-progress="6.5.7" style="left: 79.05138339920948%;"></a>
    
        <a href="../wal/checkpointcheckpoint.html" title="检查点" class="chapter  " data-progress="6.5.8" style="left: 79.24901185770752%;"></a>
    
        <a href="../references/lockandmutex.html" title="lockandmutex" class="chapter  " data-progress="6.6" style="left: 79.44664031620553%;"></a>
    
        <a href="../introduce/READMEG12.html" title="共享组件" class="chapter  new-chapter" data-progress="7" style="left: 79.64426877470356%;"></a>
    
        <a href="../introduce/crewG12.html" title="目录管理器" class="chapter  " data-progress="7.1" style="left: 79.84189723320158%;"></a>
    
        <a href="../introduce/workG12.html" title="内存分配器" class="chapter  " data-progress="7.2" style="left: 80.03952569169961%;"></a>
    
        <a href="../part2/README.html" title="动态内存分配器" class="chapter  " data-progress="7.2.1" style="left: 80.23715415019763%;"></a>
    
        <a href="../part2/mem0c.html" title="空操作内存分配器（mem0.c）" class="chapter  " data-progress="7.2.1.1" style="left: 80.43478260869566%;"></a>
    
        <a href="../part2/mem1c.html" title=" 缺省内存分配器（mem1.c）" class="chapter  " data-progress="7.2.1.2" style="left: 80.63241106719367%;"></a>
    
        <a href="../part2/mem2c.html" title="调试内存分配器（mem2.c）" class="chapter  " data-progress="7.2.1.3" style="left: 80.8300395256917%;"></a>
    
        <a href="../part2/backtrace.html" title="关于backtrace" class="chapter  " data-progress="7.2.1.3.1" style="left: 81.02766798418972%;"></a>
    
        <a href="../part2/2_3_2.html" title="设置哨兵对内存破坏进行检查" class="chapter  " data-progress="7.2.1.3.2" style="left: 81.22529644268775%;"></a>
    
        <a href="../part2/unfree_list.html" title="通过unfree list检查内存泄露" class="chapter  " data-progress="7.2.1.3.3" style="left: 81.42292490118577%;"></a>
    
        <a href="../part2/2_4.html" title="内存分配函数" class="chapter  " data-progress="7.2.1.4" style="left: 81.6205533596838%;"></a>
    
        <a href="../mem/README.html" title="内存分配器" class="chapter  " data-progress="7.2.2" style="left: 81.81818181818181%;"></a>
    
        <a href="../mem/article.html" title="mem0.c" class="chapter  " data-progress="7.2.2.1" style="left: 82.01581027667984%;"></a>
    
        <a href="../mem/mem1c.html" title="mem1.c" class="chapter  " data-progress="7.2.2.2" style="left: 82.21343873517786%;"></a>
    
        <a href="../mem/mem2c.html" title="mem2.c" class="chapter  " data-progress="7.2.2.3" style="left: 82.41106719367589%;"></a>
    
        <a href="../mem/mem3c.html" title="mem3.c" class="chapter  " data-progress="7.2.2.4" style="left: 82.6086956521739%;"></a>
    
        <a href="../mem/mem4c.html" title="mem5.c" class="chapter  " data-progress="7.2.2.5" style="left: 82.80632411067194%;"></a>
    
        <a href="../part3/README.html" title="Mem3.c代码分析" class="chapter  " data-progress="7.2.3" style="left: 83.00395256916995%;"></a>
    
        <a href="../part3/mem3c.html" title="Mem3.c功能概述" class="chapter  " data-progress="7.2.3.1" style="left: 83.20158102766798%;"></a>
    
        <a href="../part3/3_1.html" title="名词及相关概念" class="chapter  " data-progress="7.2.3.2" style="left: 83.39920948616601%;"></a>
    
        <a href="../part3/3_3.html" title="块存储结构 " class="chapter  " data-progress="7.2.3.3" style="left: 83.59683794466403%;"></a>
    
        <a href="../part3/3_3_1.html" title="内存分配结构体 " class="chapter  " data-progress="7.2.3.3.1" style="left: 83.79446640316206%;"></a>
    
        <a href="../part3/3_4.html" title="Mem3.c函数列表" class="chapter  " data-progress="7.2.3.4" style="left: 83.99209486166008%;"></a>
    
        <a href="../part3/3_5.html" title="函数代码解析" class="chapter  " data-progress="7.2.3.5" style="left: 84.18972332015811%;"></a>
    
        <a href="../part4/article.html" title="mem5.c" class="chapter  " data-progress="7.2.4" style="left: 84.38735177865613%;"></a>
    
        <a href="../part4/41_mem5c.html" title="mem5.c功能概述" class="chapter  " data-progress="7.2.4.1" style="left: 84.58498023715416%;"></a>
    
        <a href="../part4/mem5cc.html" title="mem5.c调用的C接口" class="chapter  " data-progress="7.2.4.2" style="left: 84.78260869565217%;"></a>
    
        <a href="../part4/43.html" title="名词及相关概念" class="chapter  " data-progress="7.2.4.3" style="left: 84.9802371541502%;"></a>
    
        <a href="../part4/44.html" title="函数及结构体功能" class="chapter  " data-progress="7.2.4.4" style="left: 85.17786561264822%;"></a>
    
        <a href="../part4/45.html" title="重要代码解析" class="chapter  " data-progress="7.2.4.5" style="left: 85.37549407114625%;"></a>
    
        <a href="../mallocc/README.html" title="Malloc.c" class="chapter  " data-progress="7.2.5" style="left: 85.57312252964427%;"></a>
    
        <a href="../mallocc/future.html" title="特性" class="chapter  " data-progress="7.2.5.1" style="left: 85.7707509881423%;"></a>
    
        <a href="../mallocc/test.html" title="测试" class="chapter  " data-progress="7.2.5.2" style="left: 85.96837944664031%;"></a>
    
        <a href="../mallocc/config.html" title="配置" class="chapter  " data-progress="7.2.5.3" style="left: 86.16600790513834%;"></a>
    
        <a href="../mallocc/api.html" title="API介绍" class="chapter  " data-progress="7.2.5.4" style="left: 86.36363636363636%;"></a>
    
        <a href="../mallocc/summry.html" title="总结" class="chapter  " data-progress="7.2.5.5" style="left: 86.56126482213439%;"></a>
    
        <a href="../introduce/dynamicmemorymalloc.html" title="dynamicmemorymalloc" class="chapter  " data-progress="7.2.6" style="left: 86.7588932806324%;"></a>
    
        <a href="../conclusion/README.html" title="其他工具" class="chapter  " data-progress="7.3" style="left: 86.95652173913044%;"></a>
    
        <a href="../sqlite/sqlitelimiteh.html" title="SqliteLimite.h" class="chapter  " data-progress="7.3.1" style="left: 87.15415019762845%;"></a>
    
        <a href="../sqlite/sqliteinth.html" title="SqliteInt.h" class="chapter  " data-progress="7.3.2" style="left: 87.35177865612648%;"></a>
    
        <a href="../sqlite/globalc.html" title="Global.c模块源码分析" class="chapter  " data-progress="7.3.3" style="left: 87.5494071146245%;"></a>
    
        <a href="../mainc/READMEG16.html" title="主函数分析" class="chapter  " data-progress="7.3.4" style="left: 87.74703557312253%;"></a>
    
        <a href="../vdbeInt&amp;vdbemem887/vdbememc887.html" title="vdbemem.c分析" class="chapter  " data-progress="7.3.4.1" style="left: 87.94466403162055%;"></a>
    
        <a href="../vdbemem/vdbememsqlitevdbe.html" title="SQLite的虚拟机" class="chapter  " data-progress="7.3.4.1.1" style="left: 88.14229249011858%;"></a>
    
        <a href="../vdbemem/vdbememvdbememccode.html" title="结构体&quot;Mem&quot;的操作函数-vdbemem.c" class="chapter  " data-progress="7.3.4.1.2" style="left: 88.3399209486166%;"></a>
    
        <a href="../mainc/hanshu.html" title="函数功能" class="chapter  " data-progress="7.3.4.2" style="left: 88.53754940711462%;"></a>
    
        <a href="../mainc/caozuo.html" title="操作控制" class="chapter  " data-progress="7.3.4.3" style="left: 88.73517786561264%;"></a>
    
        <a href="../printf/printfsqlite.html" title="Printf.c分析" class="chapter  " data-progress="7.3.5" style="left: 88.93280632411067%;"></a>
    
        <a href="../printf/datatype.html" title="数据类型定义" class="chapter  " data-progress="7.3.5.1" style="left: 89.1304347826087%;"></a>
    
        <a href="../printf/sqlite3AppendSpace.html" title="sqlite3AppendSpace()函数" class="chapter  " data-progress="7.3.5.2" style="left: 89.32806324110672%;"></a>
    
        <a href="../printf/sqlite3vxprintf.html" title="sqlite3VXPrintf()函数" class="chapter  " data-progress="7.3.5.3" style="left: 89.52569169960475%;"></a>
    
        <a href="../printf/sqlite3straccumappend.html" title="sqlite3StrAccumAppend()函数" class="chapter  " data-progress="7.3.5.4" style="left: 89.72332015810277%;"></a>
    
        <a href="../printf/sqlite3straccumfinish.html" title="*sqlite3StrAccumFinish()函数" class="chapter  " data-progress="7.3.5.5" style="left: 89.9209486166008%;"></a>
    
        <a href="../printf/sqlite3straccumreset.html" title="sqlite3StrAccumReset()函数" class="chapter  " data-progress="7.3.5.6" style="left: 90.11857707509881%;"></a>
    
        <a href="../printf/sqlite3straccuminit.html" title="sqlite3StrAccumInit()函数" class="chapter  " data-progress="7.3.5.7" style="left: 90.31620553359684%;"></a>
    
        <a href="../printf/sqlite3vmprintf.html" title="*sqlite3VMPrintf()函数" class="chapter  " data-progress="7.3.5.8" style="left: 90.51383399209486%;"></a>
    
        <a href="../printf/sqlite3mprintf.html" title="*sqlite3MPrintf()函数" class="chapter  " data-progress="7.3.5.9" style="left: 90.71146245059289%;"></a>
    
        <a href="../printf/sqlite3mappendf.html" title="*sqlite3MAppendf()函数" class="chapter  " data-progress="7.3.5.10" style="left: 90.9090909090909%;"></a>
    
        <a href="../printf/sqlite3_vmprintf.html" title="*sqlite3_vmprintf()函数" class="chapter  " data-progress="7.3.5.11" style="left: 91.10671936758894%;"></a>
    
        <a href="../printf/sqlite3_mprintf.html" title="*sqlite3_mprintf()函数" class="chapter  " data-progress="7.3.5.12" style="left: 91.30434782608695%;"></a>
    
        <a href="../printf/sqlite3_vsnprintfsqlite3_snprintf.html" title="*sqlite3_vsnprintf()函数；*sqlite3_snprintf()函数" class="chapter  " data-progress="7.3.5.13" style="left: 91.50197628458498%;"></a>
    
        <a href="../printf/renderlogmsg.html" title="renderLogMsg()函数" class="chapter  " data-progress="7.3.5.14" style="left: 91.699604743083%;"></a>
    
        <a href="../printf/sqlite3_log.html" title="sqlite3_log()函数" class="chapter  " data-progress="7.3.5.15" style="left: 91.89723320158103%;"></a>
    
        <a href="../printf/sqlite3debugprintf.html" title="sqlite3DebugPrintf()函数" class="chapter  " data-progress="7.3.5.16" style="left: 92.09486166007905%;"></a>
    
        <a href="../printf/sqlite3xprintf.html" title="sqlite3XPrintf()函数" class="chapter  " data-progress="7.3.5.17" style="left: 92.29249011857708%;"></a>
    
        <a href="../date/datecG22.html" title="date.c模块源码分析" class="chapter  " data-progress="7.3.6" style="left: 92.4901185770751%;"></a>
    
        <a href="../date/datestruct.html" title="主要结构体" class="chapter  " data-progress="7.3.6.1" style="left: 92.68774703557312%;"></a>
    
        <a href="../date/getsystem.html" title="获取系统读数" class="chapter  " data-progress="7.3.6.2" style="left: 92.88537549407114%;"></a>
    
        <a href="../date/gettimediff.html" title="读取时区差异扩展表示格式" class="chapter  " data-progress="7.3.6.3" style="left: 93.08300395256917%;"></a>
    
        <a href="../date/changetime.html" title="正常时间与儒略日数之间的相互转换" class="chapter  " data-progress="7.3.6.4" style="left: 93.28063241106719%;"></a>
    
        <a href="../date/julian_day_number.html" title="转换为Julian Day Number所发生的的错误个数" class="chapter  " data-progress="7.3.6.5" style="left: 93.47826086956522%;"></a>
    
        <a href="../date/getcurrenttime.html" title="获取系统当前时间" class="chapter  " data-progress="7.3.6.6" style="left: 93.67588932806323%;"></a>
    
        <a href="../date/grammaroptimize.html" title="时间戳的语法改良" class="chapter  " data-progress="7.3.6.7" style="left: 93.87351778656127%;"></a>
    
        <a href="../date/timeshow.html" title="时间的表示" class="chapter  " data-progress="7.3.6.8" style="left: 94.07114624505928%;"></a>
    
        <a href="../sqlite/utilCode.html" title="util.c分析" class="chapter  " data-progress="7.3.7" style="left: 94.26877470355731%;"></a>
    
        <a href="../utf.c&amp;vacuum/utf.html" title="utf.c分析" class="chapter  " data-progress="7.3.8" style="left: 94.46640316205534%;"></a>
    
        <a href="../date/ctimec.html" title="Ctime.c模块源码分析" class="chapter  " data-progress="7.3.9" style="left: 94.66403162055336%;"></a>
    
        <a href="../printfc/printfc.html" title="Printf.c" class="chapter  " data-progress="7.3.10" style="left: 94.86166007905139%;"></a>
    
        <a href="../printfc/updatecprgn.html" title="功能" class="chapter  " data-progress="7.3.10.1" style="left: 95.0592885375494%;"></a>
    
        <a href="../printfc/hdy.html" title="宏定义" class="chapter  " data-progress="7.3.10.2" style="left: 95.25691699604744%;"></a>
    
        <a href="../printfc/jgt.html" title="结构体" class="chapter  " data-progress="7.3.10.3" style="left: 95.45454545454545%;"></a>
    
        <a href="../printfc/function.html" title="函数" class="chapter  " data-progress="7.3.10.4" style="left: 95.65217391304348%;"></a>
    
        <a href="../printfc/et_getdigit.html" title="et_getdigit" class="chapter  " data-progress="7.3.10.4.1" style="left: 95.8498023715415%;"></a>
    
        <a href="../printfc/sqlite3appendspace.html" title="sqlite3AppendSpace" class="chapter  " data-progress="7.3.10.4.2" style="left: 96.04743083003953%;"></a>
    
        <a href="../printfc/sqlite3vxprintf.html" title="sqlite3VXPrintf" class="chapter  " data-progress="7.3.10.4.3" style="left: 96.24505928853755%;"></a>
    
        <a href="../printfc/qths.html" title="其他函数" class="chapter  " data-progress="7.3.10.4.4" style="left: 96.44268774703558%;"></a>
    
        <a href="../date/datec1.html" title="date.c模块源码分析(1)" class="chapter  " data-progress="7.3.11" style="left: 96.6403162055336%;"></a>
    
        <a href="../date/datec.html" title="date.c模块源码分析(2)" class="chapter  " data-progress="7.3.12" style="left: 96.83794466403162%;"></a>
    
        <a href="../conclusion/forexample" title="forexample" class="chapter  " data-progress="7.3.13" style="left: 97.03557312252964%;"></a>
    
        <a href="../sqlite/completec.html" title="complete.c模块源码分析" class="chapter  " data-progress="7.4" style="left: 97.23320158102767%;"></a>
    
        <a href="../sqlite/callbackc.html" title="callback.c模块源码分析" class="chapter  " data-progress="7.5" style="left: 97.43083003952569%;"></a>
    
        <a href="../sqlite/hash.html" title="Hash" class="chapter  " data-progress="7.6" style="left: 97.62845849802372%;"></a>
    
        <a href="../introduce/sqliteG12.html" title="Sqlite源代码介绍" class="chapter  " data-progress="7.7" style="left: 97.82608695652173%;"></a>
    
        <a href="../clp/shellclp.html" title="Shell模式下使用CLP" class="chapter  new-chapter" data-progress="8" style="left: 98.02371541501977%;"></a>
    
        <a href="../clp/dosclp.html" title="命令行模式下的CLP" class="chapter  " data-progress="8.1" style="left: 98.22134387351778%;"></a>
    
        <a href="../function/api.html" title="重要的API函数" class="chapter  " data-progress="8.2" style="left: 98.41897233201581%;"></a>
    
        <a href="../function/user.html" title="用户自定义函数" class="chapter  " data-progress="8.3" style="left: 98.61660079051383%;"></a>
    
        <a href="../result/code.html" title="结果代码" class="chapter  " data-progress="8.4" style="left: 98.81422924901186%;"></a>
    
        <a href="../sqlfuncc/README.html" title="实现SQL的各种函数(func.c的源码分析)" class="chapter  new-chapter" data-progress="9" style="left: 99.01185770750988%;"></a>
    
        <a href="../sqlfuncc/jisuan.html" title="算术函数" class="chapter  " data-progress="9.1" style="left: 99.2094861660079%;"></a>
    
        <a href="../sqlfuncc/zifu.html" title="字符处理函数" class="chapter  " data-progress="9.2" style="left: 99.40711462450592%;"></a>
    
        <a href="../sqlfuncc/tiaojian.html" title="条件判断函数" class="chapter  " data-progress="9.3" style="left: 99.60474308300395%;"></a>
    
        <a href="../sqlfuncc/jihe.html" title="集合函数" class="chapter  " data-progress="9.4" style="left: 99.80237154150197%;"></a>
    
        <a href="../sqlfuncc/qita.html" title="其他函数" class="chapter  " data-progress="9.5" style="left: 100%;"></a>
    
    </div>
</div>

                <div class="page-inner">
                
                    <section class="normal" id="section-gitbook_8">
                    
                        <h1 id="">页面溢出</h1>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;有效载荷及其内容可有不同的大小。然而，页面大小是固定不变的。因此，给定的有效载荷总有可能超出单页装载大小。这种情况发生时，额外的有效载荷将添加到溢出页面的链接链表上。由此看来，有效载荷将在有序的链接链表中显示，如图5所示。
<img src="5overflow.jpg">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;图5中第4个有效载荷超出了当前页所能装载的大小。因此，B-tree模块创建了溢出页来装载。实际上，一个溢出页也不能装载，因此，又链接了第二个溢出页。这实际上就是处理二进制大对象的方法。使用真正的大字段时，最后都采用页链接链表来存储。如果blob字段太大，这种方式效率很低，此时，可考虑创建外部文件来存储blob数据，并将外部文件名保存在记录中。</p>

                    
                    </section>
                
                </div>
            </div>
        </div>

        
        <a href="../B-treeImplementation/hierarchicalorganization.html" class="navigation navigation-prev " aria-label="Previous page: SQLite层次化数据组织"><i class="fa fa-angle-left"></i></a>
        
        
        <a href="../B-treeImplementation/b-tree_api.html" class="navigation navigation-next " aria-label="Next page: B-tree API"><i class="fa fa-angle-right"></i></a>
        
    </div>
</div>

        
<script src="../gitbook/jsrepl/jsrepl.js" id="jsrepl-script"></script>
<script src="../gitbook/app.js"></script>

    
    <script src="https://cdn.mathjax.org/mathjax/2.0-latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
    

    
    <script src="../gitbook/plugins/gitbook-plugin-mathjax/plugin.js"></script>
    

<script>
require(["gitbook"], function(gitbook) {
    var config = {};
    gitbook.start(config);
});
</script>

        
    </body>
    
</html>
